Hi,
I have a key figure measurement amount which i am using in the query.
Here i have created a selection in the columns, which has the measurement amount and gross area restricted to some value.
and named the selection as %MA. went into the properties of the selection and selected Calculated Single Value as... "Normalize Sub Totals" and slected the check box also apply to results and selected "calculated along the rows."
Now the problem here i am facing is i am getting negative values for %MA. I wanted to hide these negative sign.
As the percentage is getting calculated dynamically at query runtime, i am facing the issue of hiding the negative sign.
For example: if the value is -37.345%, i want to show 37.345%
Can anyone help
Thanks
Rani.