Skip to Content
0

Need to add amounts on Condition

May 02, 2017 at 10:02 AM

29

avatar image

Hi Experts,

I have a BO Report giving me results of Credit and Debit of amounts for various gl accounts

10 |10000 characters needed characters left characters exceeded

Below is the ref data

We are not showing the Debit _credit column in the report

GL AccountExportTax AmountNet Accumulated AmountGross AmountPeriod(Month)Legacy File NumberSource System179057Y3329380,19201703140RFBACC297903Y-3329380,19201703140RFBACC605024Y360185,98201703140RFBACC299957Y-360185,98201703140RFBACC

but my requirement is to show the Net Accumulated amount which would be

as below

Debit CreditTax AmountGross AmountNet AccumulatedD3689566,17C-3689566,17

I tried using FORALL functions but could not get closer to the desired result.

Any help would be appreciated.

0
* Please Login or Register to Answer, Follow or Comment.

3 Answers

AMIT KUMAR
May 02, 2017 at 10:23 AM
0

if you are not showing Debit _credit column in the report then you need to use Foreach in the formula for calculaiton.

Share
10 |10000 characters needed characters left characters exceeded
Sachin Joshi May 02, 2017 at 10:32 AM
0

Amit, I had tried that only but the result is not as per expectation.

I'm giving sample data below

GL_Account Export Net Accumulated Amount Period(Month) File_Nbr Source
179057 Y 3329380,19 201703 140 RFBACC
297903 Y -3329380,19 201703 140 RFBACC
605024 Y 360185,98 201703 140 RFBACC
299957 Y -360185,98 201703 140 RFBACC

Now when we have 2 negative figures they represent D while positive amount stands for Credit

These 2 amnounts need to be shown explicity on the fly in Report.We are on

SAP BusinessObjects BI Platform 4.1 Support Pack 5 Patch 7

Share
10 |10000 characters needed characters left characters exceeded
Sachin Joshi May 02, 2017 at 10:35 AM
0

Just to add the below is the desired output ::

Debit Credit Net Accumulated
D 3689566,17
C -3689566,17

Share
10 |10000 characters needed characters left characters exceeded