Skip to Content
0
Former Member
May 20, 2008 at 05:30 AM

hiding the negative sign for KeyFigure which is calculated dynamically

30 Views

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.