Dynamic Field Calculation

[Mike CPB]

I have a balance sheet with services of different types. I'm trying to create a past due function.

Now there are different services provided at different times of the year.

So I'm wondering if there is a way to control the field calculation?

I was thinking of linking the calculation to a global field that I could change with a check box.

My first attempts are simply creating a literal text link, they aren't really performing calculations to related fields.

Maybe this type of connection isn't permitted within filemaker... Any idea's would be greatly appreciated.

My current resolve is to create every possible situation with its own field and calculation and manually change which field calc I wish to display during past due printing.

[mr_vodka]

Why dont you just create one calc using a Case statement?

Case ( service ="a"; Amt + Fee;

service ="b"; Amt + Discount;

service ="c"; Amt + tax

)