5 Replies Latest reply on Jan 23, 2019 12:38 PM by NAYANA MADHEKAR

    Alias in IF condition

    NAYANA MADHEKAR

      Hello,

       

      I have a calculated field ( Default properties %)

       

      if A>0 then 0.08 else 0.0 END

       

      The result is either 8% or 0%.

       

      I have such conditions for multiple calculated fields which I later Total all percentages to show a Final Score. (Therefore properties cant be changed)

       

       

       

      But I want to display points instead of percentages. (only for display).

       

      Eg 8 points or 0 points...

       

      Is this possible? May be if I can edit alias to these values in the condition itself?

      if [Weekly Recap]>0 then 0.08 alias 8 points else 0.0 alais 0 points END????

       

      Thank you.