IF logic in bex Query, only want to calculate keyfiugre with all values.

[Former Member]

Hi !

I have a pushasing flow with folowing key figur. But Im missing the invoice value but have the difference beetween them.

_____________Invoice Quantiy | PO value (Good issue) | Invoice value | PO vs Inv diff |

example one________2________________10 eur__________(10+1)_____________ 1_________this case ok

exemple 2 ________blank_____________10 eur___________(10+blank) _________blank______havent recived any invoice yet invoce value should not be calculated

My problem is that the invoice value should only shown then I have a Invoice Quantity.

I think its best to look at quatity because there mayby hard to differs on blank and 0 in the logic.

Do any one now a good solution on this, missing the IF statsments in BEX, its a 3.5 BW installation.

How should the logic look like ?

regards

Nicke

Edited by: Nicklas Åslund on Oct 16, 2008 8:28 AM

Edited by: Nicklas Åslund on Oct 16, 2008 8:31 AM

[Former Member]

this helped me

(( 'Cumulative Value GC' > 0 ) * 'Dummy Key Figure') + (( 'Cumulative Value GC' <= 0 ) * 15)

If 'Cumulative Value GC' > 0.

rslt = 'Dummy Key Figure'.

else.

rslt = 15.

endif.

this help me to writ the logic

[Former Member]

This helped me

Nicke

[Former Member]

Hi Nicklas,

First create a calculated keyfigure for Actual Invoice Value = Absolute values of [Invoice value - PO value (Good issue)]

Then calculate PO vs Inv diff = PO Value - Actual Invoice Value

Hope it Helps

Srini