2 Replies Latest reply on Jan 24, 2019 1:55 PM by Sharlene Engstrom

    IF THEN ELSE WITH CALCULATED FIELD

    Sharlene Engstrom

      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