SUMMARIZING THE AMOUNT WITH MULTIPLE BUSINESS UNIT

[dunkindonut7777]

Hi,

Can you help me to solve my problem regarding the summarization of amount? I just used the summarized tool but it seems it's still not being summed up according to its business unit.

I want to form it like this:

GL_ACCOUNT_CODE	FUNCTIONAL_BEG_BALANCE	FUNCTIONAL_CLOSING_BALANCE	REPORTING_CURRENCY_CODE	FUNCTIONAL_CURRENCY_CODE	BUSINESS_UNIT
10010224	0	0	USD	USD	I3
10010224	1296140.14	958394.42	USD	USD	I5
10010224	315537.52	299499.25	USD	USD	I9

 Can you help me with this one? 

[atcodedog05]

Hi @dunkindonut7777 

Here is a workflow for the task.

Output:

Workflow:

Hope this helps 🙂 Feel to ask if you have any questions

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

[Qiu]

@dunkindonut7777 
Same with @atcodedog05 , see below.

[StephV]

Hi @dunkindonut7777 ,

Thank you for your question to the Community!

If the @Qiu's or @atcodedog05's posts helped you please mark it as solution, so others can easily find it. 

Let us know how it goes!

Cheers,

[Qiu]

@StephV 
Thank you😁