5 Replies Latest reply on Dec 15, 2016 1:19 AM by Mahfooj Khan

    How to compute % of 2 variables using LOD

    Emily Z

      Hi All,

       

      I encountered problem computing % of 2 variables when the 2 variables are selecting different stage in their 'if' statement.

       

      1st variable: { INCLUDE [Stage]:IF MIN([Stage])='Won' THEN COUNTD([Order No]) END}

      2nd variable: { INCLUDE [Stage]:IF MIN([Stage])='Lost' THEN COUNTD([Order No]) END}

       

      What I want to get is the % ratio of 1st variable. I wrote the following formula but it gives me null result. Anyone can help? Thanks!

      [1st variable]/([1st variable]+[2nd variable])

       

      Emily