Update Calculated Fields

[Alan]

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

[jcompagner]

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?

[Alan]

I have a field that can be changed that is not in the calculation itself.
If ordertype = "Customer"
total = a*b
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.

[jcompagner]

i sitll don't know exactly what you have.

do you have a calculation "total"
that does:

If(ordertype = "Customer")
return a*b;
else if(ordertype = "Inter Division")
return a* c;

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