Showing results for 
Search instead for 
Did you mean: 

Number of decimal places depending on scaling factor

Former Member
0 Kudos


i implemented a CKF with a formula variable (scaling factor) with default value 1.

If the value of the scaling factor is 1 the number of decimal places should be 2 respect. the value should be displayed in following way (123.456,12)

Elsewise (scaling factor is 1000 or 1000000) the number of decimal places should be 0 respect. i expect (123) for scaling faktor 1000

Knows anyone of you how i can solv it?



Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos


Lets say you have 2 Columns in the query.

first one is formula variable which is named as scaling factor.

Second One is a KF of the data target.

Hide the second column.

And take one more formula as Third column in the report.

Here in the formula of third column take the defination like this.

FRAC ( Column 2 )/ ( 100 * Column1 )

And take <i>no of Decimal places</i> for third column as 0.

With rgds,

Anil Kumar Sharma .P

Message was edited by:

Anil Kumar Sharma

Active Contributor
0 Kudos

May not be possible.