3 Replies Latest reply: May 30, 2017 2:33 AM by Jonathan Dienst RSS

    Convert the if statement into a set analysis expression

    DIVYA ANAND

      Hi,

       

      Can someone help me write the following expression using set analysis? I have to ignore the selections in fields Year & Month, for which I have to use Set analysis.

       

       

      if(Value>0,Value, Value_FIRST - above([Total quantity]))

       

      here [Total quantity] is another column in the straight table.

       

      FYI- the expression for [Total quantity] is

         

      fabs(Sum(
      {$<Year=,Month=,
      code={100,201,306,500}
      >}
      ValueZ))

       

      Thank you.