IF logic in bex Query, only want to calculate keyfiugre with all values.
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 ?
Edited by: Nicklas Åslund on Oct 16, 2008 8:28 AM
Edited by: Nicklas Åslund on Oct 16, 2008 8:31 AM