BEx Formula

[Former Member]

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.

[Former Member · Accepted solution]

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 · Accepted solution]

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

Best regards,

Torbjorn

[Former Member]

Thank you Guys.

It is working fine.

[Former Member]

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

thanks.

Wond

[former_member188975]

Hi John,

You can use the function ABS for the new formula.

Hope this helps...