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.