Update Calculated Fields

How do I force an update of calculated fields? I can’t find the post.

you can set it to null then it should refresh.

But why do you need it. It should refresh by it self. Do you have a example where you see an calculation not updating?

I have a field that can be changed that is not in the calculation itself.
If ordertype = “Customer”
total = ab
if ordertype = “Inter Division”
total = a
c

etc

I want the calculation to update based on ordertpye. I am doing this because I cannot make fields invisible at the print preview level. Otherwise I will have to make mutliple invoice layouts for each order type.

i sitll don’t know exactly what you have.

do you have a calculation “total”
that does:

If(ordertype = “Customer”)
return ab;
else if(ordertype = “Inter Division”)
return a
c;

this should work fine. so please send an example..