Add Calculation to Text Widget

Question

My dataset has figures (percentages) but I need to convert the values into the correct format by multiplying by 100.

So for instance, 0.1 means 10%. I also need to truncate/round to 2 decimal places.

 Is this possible to achieve in the Text Widget?

Something like 

AVG($F{MY_Dataset.Market_Share})*100

The final display value should be the average of all percentages. The part of average calculation is working ok but the result needs to be formatted to a 2 decimal percentage.

Answer 1

Hi,

the text widget borned only to show textual messges, so -for the moment- the system is able to manage only the aggregation functions pre-defined. Isn't possible add different aritmethical operations. So, I think you have to make the percentage conversion directly by the dataset and use it into the text-widget.

Bye.