Decimal value less than 1% gives me wrong %.

[#1]

Hello, I need help. I am using this '##.#0%' to show XX.XX% format for my column. But when it becomes less than 1%, lets say 0.95% it should show me 0.95%. But its showing me 95%. Anyone

[#2]

Chirstian, i get 260,65%. Which exceeds more than 100. Still not getting to find solution

[christian77]

To build a calculated dimension, the object has to understand what are you dimensionning. Therefore, enclose your expression in an aggr funcktion like:

aggr(if(Month>3, Month), Month)

That way the object knows what dimension you want exactly. In this case it'll show months.

aggr(if(Month>3, Week), Month) or aggr(if(Month>3, Week), Week)

Some people don't like calculated dimensions cause the take longer time to calculate. I think depends on what dimension we use. It's is better to have it on the script. Sometimes I don't want to touch the script for only a table.

good luck.

[christian77]

Go to the script and see how is yor var definition at the top of the first page. Is it in Spanish?

Go to document properties and in the tab Number, check the quality of your data.
If you're getting undesired data formats, control that at the script by appling funcktions to set the correct formats.

[#5]

Many thanks. It worked now