Skip to Content
Former Member
Apr 22, 2010 at 09:35 AM

Calculated Key figure Formula Logic


HI All;)

We are on BI 7.

We are having an issue with a formula in a calculated key figure as below.

((PO Value - Invoiced Amt <0) *0 + (( PO Value - Invoiced Amt ) > 0) * NODIM (( PO Value - Invoiced Amt))

The problem with the above formula is that ialthough it works if the second half of the formula condition is met the NODIM removes the currency from the results amount displayed. i.e 50,500 not £50,500

If we remove the NODIM from the query the query as below it has errors and can not be used as below?

((PO Value - Invoiced Amt <0) *0 + (( PO Value - Invoiced Amt ) > 0) * ( PO Value - Invoiced Amt)

We are wondering if there is an issue with currencies in the above example that does not use NODIM?

Thankyou for your time and assistance in advance

Kind regards