Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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

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 ?



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

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

Former Member
Not what you were looking for? View more on this topic or Ask a question