Scaling data

[#1]

Hi All,

Please refer the attached QVW file.

I want that the Total of all the 3 expression should not be more than 100.

Here in the chart data for 179272 is 51+44+7=102. I want to restrict it to 100.

Is there any way to do this? I tried to use static max as well but could not resolve it.

Please let me the solution for the same.

Thanks in advance

[#2]

It is always 100 or is it the nearest multiple of 100? You could use Round(<EXPRESSION>,100) for the latter.

/emb