Formula Help (Currency field to display Text)

Alex,

Expanding a bit on Blakes answer, you need two fields.

One is Numeric Currency field so that you can continue do calculations on the money.  

• If([Selection]="Included" or [Selection]="Optioned" or [Selection]="Included in Change Order", [Qty]*[Cost], 0)

This gives you either the Quantity * Cost or zero.   Use this for summary or table reports where you  then need it to be added with other records.

Then you need  Formula Text Field to show on Forms or special reports where you do not expect the column to add up to a total

var number CalculatedCost = If([Selection]="Included" or [Selection]="Optioned" or [Selection]="Included in Change Order", [Qty]*[Cost], 0)l;

If ( $CalculatedCost<>0, "$ " &ToText($CalculatedCost), "TBD")

------------------------------
Don Larson
Paasporter
Westlake OH
------------------------------