9 Replies Latest reply on Aug 13, 2018 12:22 PM by Okechukwu Ossai

    How to fix the level (LOD) issues in my If formula

    Helen Wang

      Hi All,

       

      I want to use this formula but i have some difficulties:

       

      IF [Product Line]= "CABLE" THEN [Moving_avg 6W]*13*1.25

      ELSE [Moving_avg 6W]*13*1.12

      END

       

      I want to specific saying that, when Product line is cable, it used a different formula. But LOD has issues.

       

      Please help.

       

      Under Product Line, there is product category, and Item numbers.

       

      Thanks,

      Helen