cancel
Showing results for 
Search instead for 
Did you mean: 

BEx Formula

Former Member
0 Kudos

Hello Friends,

I have question on finance reporting requirement.

I have one selection in structure say ABC.

This selection has one KF which has both negative and positive values.

I want to make new formula to include this selection and make it explicitly positive each time.

Can anyone help me with syntax of this formula.

Thanks,

John.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hello Friends,

I have one KF which gives positive and negative values.

What should be the formula to have positive as negative and negative as positive.

I have tried reverse sign, but that is only for the display purpose.

Because when I am using this formula elsewhere it is taking the sign of the KF and not the reverse sign.

Please Help.

Thanks,

John.

Former Member
0 Kudos

Multiply your key figure with (-1) in your formula.

Best regards,

Torbjorn

Answers (3)

Answers (3)

Former Member
0 Kudos

Thank you Guys.

It is working fine.

Former Member
0 Kudos

In the formula you can use absolute value which will return positive all the time.

thanks.

Wond

former_member188975
Active Contributor
0 Kudos

Hi John,

You can use the function ABS for the new formula.

Hope this helps...