Skip to Content
Former Member
May 01, 2009 at 08:26 PM

How to split amounts in Key Figure in 2 different columns based on cond



I am trying to accomplish the following.

I have a key figure called amount in transaction currency. The values are get are positive and negative amounts.

The requirement is that I have 2 separate columns in the query/report where one column would have only positive values or 0, and another one all the negative values.

basically they want to see disbursements and credits in 2 separate columns.

Anybody knows how to accomplish that with BEx Query Designer.

P.S. I am running BI 7.0 and using BEx WEB analyzer to display queries.

Thank you