8 Replies Latest reply on Jul 9, 2018 2:58 PM by user9928941

    IF("Gross Sales"==#missing) - not working

    2625007

      Hi Here is my below code snippet and its not working in PBCS calculation manager business rule.

       

      I have tried multiple times (with only IF gross sales==#missing) etc, but no luck.

       

      FIX("Actual","FINAL", @RELATIVE("Total Departments",0))

      "SGA Account"

      (

        IF( "SGA Account"->"Customer_NA"->"ProductTarget" <> #MISSING)

               IF("Gross Sales"==#Missing or "gross sales"==0)

              "SGA"->"MSC"->@MEMBER(@CONCATENATE("MISC-",@NAME(@SUBSTRING(@NAME(@CURRMBR("Product")),2,6)))) = "SGA"->"Customer_NA"->"ProductTarget";

      ENDIF

      ENDIF

      )