2 Replies Latest reply: Jan 3, 2012 9:49 AM by Daniel Sturesson RSS

    Change number format on Y axis

      Hi.

       

      In order to be able to show both the sum of an expression and the percentage in the same graph I have created a button that changes the value of the variable "Procent" to 1 or 0.

       

      In the chart I have done the following:

       

      if(Procent = 1,

        num(Sum (AntalTotalt)/Sum (TOTAL <ÅrMånad> AntalTotalt), '# ##0,0%'),

                Sum (AntalTotalt)

      )

       

       

      I'm using the num() in order to change the values from 0,75 to 75%.

      This works great in the actual chart but the Y-axis still shows 0,00 to 1 and not 0% to 100%.

       

      Any ideas on how to fix this?

       

      //Daniel