percentage

[ratnalein]

Hallo everyone,

I was trying to build a percentage for a measure data element:

Code Select Expand


percentage([Number of sick People]/[Total number People])


It gives me the wrong percentage.  Mhh.. something wrong with the usage of percentage?

Thank you..

Regards,

Ratna :)

[MKA]

Can't you just do the calculation in a data item and then set the format to percentage?

[ratnalein]

Hallo MKA,

thank you for the quick reply.  I can not do it in the data item, because if I do that, the values appearing in my map legend will not be formatted automatically in percentage.  I need the values in the map legend to be in percentage.

Regards,

Ratna

[Lynn]

The percentage function takes one numeric data item and returns the percentage for each occurrence based on the total of that same data item.

In the documentation example it shows 3 sales people, the sales for each, and then each sales person's percent of the total sales.

You are trying to get a percentage of one data item (sick people) relative to a different data item (total people).

I would do as MKA suggests. You can set the data format for the measure in your chart and that formatting should be reflected in the legend.