cancel
Showing results for 
Search instead for 
Did you mean: 

Number of decimal places depending on scaling factor

Former Member
0 Kudos

Hello,

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?

thx

markus

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi,

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

former_member188325
Active Contributor
0 Kudos

May not be possible.