Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
On number tab, have you select the option "expression default" for that expression?
Yes I have.
Another thing that also isn't working is "others" in pie charts. They also show 0,0023.....