In FSG, how to add the amounts of a range of GL-accounts plus a single GL-account
Hi Everyone,
I will first try to explain the scenario and then comes my question.
Scenario:
In an existing FSG report, there are a range to GL-accounts (suppose Acc1 to Acc5) already existing for which the report was giving output correctly. Now in the "account assignment" of this report, I added a second row with a specific GL-Account (say 7)so that this report reflects the YTD-balance of the specified account as well in the same report along with other accounts.
Issue and question:
Report is giving output as follows:
Acc1=100
Acc2=200
Acc3=300
Acc4=0
Acc5=400
Acc7=500
Total=500
I don't want the total to be displayed in the report OR if it displays then it should be the sum of all the accounts (but not only the last account). Let me know if you need more information and kindly advise how to get the desired result here? Thanks in Advance.