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

    Alias in IF condition




      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.