🧮 Formula Configuration — BizFlowEngine

BizFlowEngine supports formula calculations similar to Microsoft Excel. You can define formulas for UI objects using Excel-compatible syntax to perform dynamic calculations across sections and tables.

---

✍️ Defining a Simple Formula

Create a UI with two decimal fields and one formula field (type: Decimal). You can define formulas in two ways:

1. Via Object Properties Panel

• Navigate to the object’s property panel.
• Enter your formula using Excel-style syntax.
• Example:

½SEC1.TXTVAL1½ + ½SEC1.TXTVAL2½

✅ Formula fields appear in green to indicate they contain a formula.

---

2. Direct Formula Editing

• CTRL + Click on the object.
• Existing formula will appear in the lower section.
• Edit or add a new formula.
• Click Update Formula Field or Cancel to discard changes.

---

📌 Formula Tips

• Avoid spaces after function names: LEN() ✅, LEN () ❌
• Use equals instead of = for logical comparisons.
• Respect formula sequence: dependent formulas should be placed after their dependencies to improve performance.

💡 Example: Place aggregate formulas below table formulas to ensure proper calculation order.

---

🧪 Formula Examples

🔤 Text Functions

LEFT(½SEC1.TXTVAL1½, 5) RIGHT(½SEC1.TXTVAL1½, 5) MID(½SEC1.TXTVAL1½, 5, 2) LEN(½SEC1.TXTVAL1½)

📅 Date Functions

DAY(½SEC1.TXTVAL1½) MONTH(½SEC1.TXTVAL1½) YEAR(½SEC1.TXTVAL1½)

🔁 Conditional Logic

if(½SEC1.TXTVAL1½ equals 'HELLO', true, false) if(½SEC1.TXTVAL1½ equals 'HELLO', 'WORLD', 'EARTH') if(½SEC1.TXTVAL1½ equals 'HELLO', ½SEC1.TXTVAL2½ + ½SEC1.TXTVAL3½, ½SEC1.TXTVAL2½ * ½SEC1.TXTVAL3½)

---

➕ Conditional Execution with » Symbol

YEAR(½SEC1.TXTVAL1½) » ½SEC1.TXTVAL2½ > 10

This means: calculate the year only if SEC1.TXTVAL2 is greater than 10.

🧠 Using IF for Conditional Calculation

IF(½SEC1.TXTVAL2½ > 10, YEAR(½SEC1.TXTVAL1½), 0)

---

📊 Table-Based Formulas

Formulas in tables follow the same syntax as sections.

📈 Aggregate Functions (Table Only)

SUM(½SEC1.TBL.TXTAMT½) AVERAGE(½SEC1.TBL.TXTAMT½) MIN(½SEC1.TBL.TXTAMT½) MAX(½SEC1.TBL.TXTAMT½)

ℹ️ These require numeric columns in the table.

---

✅ Summary

• Use Excel-style syntax for formulas.
• Define formulas via object properties or direct editing.
• Respect formula sequence for performance.
• Use conditional logic and aggregate functions for dynamic UI behavior.
• Green color indicates formula-bound objects.

---

© BizFlowEngine — Smart Calculations for Smarter Interfaces