Hi,

I am trying to do a IF Then statement - currently looks like this: IF[Back order Qty]>[Curr E Res U Inv]THEN[Curr E Res U Inv]ELSE[Back order Qty]END

The problem is that "Curr E Res U Inv" is a calulated field : { FIXED [Product-Code]:MAX([Curr E reservation])} so that it doesnt inflate the reserved value.

The "Curr E Res U Inv" works perfectly, but when the IF formula returns the value, it does end up being inflated again as if it wasnt fixed.

I have tried amending it per the below, but the below formula is not acceptable and keeps giving errors please help.

IF[Back order Qty]>[{ FIXED [Product-Code]:MAX([Curr E reservation])}]THEN[{ FIXED [Product-Code]:MAX([Curr E reservation])}]ELSE[Back order Qty]END

Help would be greatly appreciated, Thank you