cancel
Showing results for 
Search instead for 
Did you mean: 

hiding the negative sign for KeyFigure which is calculated dynamically

Former Member
0 Kudos
57

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.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Rani,

Try creating a formula and use absolute function which is present in mathematical functions. That is

Abs(Key Fig) is your formula.

Hope this helps u

Thanks

Tulsi

Answers (1)

Answers (1)

Former Member
0 Kudos

create a formula on %MA and use absolute value function. This is available in BEx. Now. hide your original key figure( %MA) and display this new formula.

Thanks..

Shambhu