Examples

This is the formula for the Cash line:

~BeginFormula~(expr([Cash]=[Closing Cash]))~EndFormula~

This is the formula for a Gross Margin line:

~BeginFormula~(expr([Gross Margin] = [Gross Sales] – [COGS]))~EndFormula~

This is the formula for a Gross Margin Percent line:

~BeginFormula~(expr([Profit Margin Percent] = 100 * ([Gross Sales] – [COGS])/[Gross Sales]))~EndFormula~

This is the formula for a Discounts Allowed line:

~BeginFormula~(expr
(If [Trade Sales] >= 5000 Then 
[Discounts Allowed] = [Trade Sales] * 0.1;
Else
[Discounts Allowed] = [Trade Sales] * 0.05;
EndIf) 
)~EndFormula~

This is the formula for a Cost line:

~BeginFormula~(expr(if not cons
If Cost > 100000
Then [Discounts Received] = [Cost] * .1;
Else If Cost > 5000
Then [Discounts Received] = [Cost] * .05;
EndIf
EndIf))~EndFormula~

This is the formula for a Production Costs line:

~BeginFormula~(expr(if not cons
Then [Production Costs] = [Manufacturing Costs] + [Purchase Costs]; 
EndIf))~EndFormula~