4 Replies Latest reply on Aug 26, 2016 2:02 PM by David Li

    Conditionally format measure values as number vs. percentage

    Li Kim Lee

      Hello. I have a table of various measure names - measure values. A parameter allows one to select whether raw figures of % of a specific figure is shown. Each measure value contains the statements executing something like...

      IF Parameter = "Raw data"

      THEN (show raw data)

      ELSEIF Parameter = "%"

      THEN (show raw data / SUM (something))

      END

       

      However, depending on the parameter value selected, I end with either

      a) meaningful figures e.g. 23,478 and meaningless percentages e.g. 1, 0

      or

      b) non-percentages displayed for figures e.g. 77000.00% and meaningful percentages e.g. 0.74%

       

      Does a way exist for me to get meaningful figures and meaningful percentages?

       

      Thanks.