How to scale numbers in a graph made in Report Designer

Fh1
New Contributor

Good evening,

I would like to ask if it is possible to change the scaling from ##,###,###.## to ##.## in the Report Designer feature of the Report component.

The data is read from a cube view with a scaling already entered. However, because I use an MD cube view in the data adapter, the scaling set is lost. Currently, by changing the setting in the Text Pattern, the desired result does not occur; I wonder if it is possible to change the Text Pattern so that it returns the desired result. Alternatively, if there is another way to solve this problem.

Thank you

 

 

Fh1_2-1702317156089.png

 

 

1 ACCEPTED SOLUTION

JackLacava
Honored Contributor

Use a Calculated Field, it's the easiest and most powerful option. 

JackLacava_0-1702321177575.pngJackLacava_1-1702321198663.png

JackLacava_2-1702321311175.png

In the formula you can also Round your values. Any further formatting (currency, etc) will be done in the Text Pattern, because we want to keep returning pure numbers.

View solution in original post

2 REPLIES 2

JackLacava
Honored Contributor

Use a Calculated Field, it's the easiest and most powerful option. 

JackLacava_0-1702321177575.pngJackLacava_1-1702321198663.png

JackLacava_2-1702321311175.png

In the formula you can also Round your values. Any further formatting (currency, etc) will be done in the Text Pattern, because we want to keep returning pure numbers.

Fh1
New Contributor

Thank you very much @JackLacava