displaying 1000% instead of 1000.

[Former Member]

hi,

i am a problem. I executed one query. In this query i set scaling factor of one variable as 1000. So that it is displaying 1000 as scaling factor.

But i have to display 1000% instead of 1000. if i do this, data value changes, but it should not be changed.

So that i can't add something in formula.

So is there any trick so that i can display 1000% instead of 1000.

Just i have to display in report.

data is displaying like this.

variable marketing area scaling factor value

sge/net sales emea *1000 0.03

scaling factor should be 1000% instead of *1000

[Former Member]

Hello Devesh,

Try to create a new formula from with the help of Data functions and Percentage functions in Query Designer

NODIM(XYZ)%A100

where XYZ represents your current result.

And later you can hide your current result showing only the Formula result. You can also this if you are current KF adding NODIM(XYZ)%A100 if it is coming from any calculation and XYZ can be your calculation part.

Regards,

Santosh