Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have a calculation in the line chart as given below.
Sum(Survey participants)/Sum(Total Participants) * 100.
I want to display the result along with the % sign in the line chart.
Example: If the result of the above calculation is 90, then it is should display 90%. How can I do this?
Thanks,
Anusha
Remove the part "* 100" and go to Edit > Data > Your Measure > Number Formatiing > Number > 12%
Hi Ivan,
I know this. But I cannot do it because I want to display both the percentages and numbers(without percentage).
I have used qsvariable extension. when I select % from the drop down, the line chart should display the results with %. When I sleect numbers from the drop down line chart should display only numbers
Hi ,
Try the below code:
num((Sum(Survey participants)/Sum(Total Participants) * 100), '#,##0%')
Or
Use only Sum(Survey participants)/Sum(Total Participants) in the expression and on the measure field set the below formatting :
Number formatting --> Number
Formatting--> Simple--> 12%
Hope this helps...
Regards
SB
Okay, but this is not what you asked in your initial post. Please for future posts provide the full requirements.
Anyway, you can use NUM as already suggested below.
Hi Anusha,
Add Normal Expression into chart.
a) Way1:
Sum(Survey participants)/Sum(Total Participants)
In Expression Property Number format set as %.
b)Way2:
num((Sum(Survey participants)/Sum(Total Participants) ), '##,###.0%')
Thanks,
Arvind Patil
hi,
you use the expression like this: Sum(Survey participants)/Sum(Total Participants)
then go to number formatting and choose one of 12%, 12.X% or 12.XX% options.
hope it helps,
Andrei.