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