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



      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.