Forum Discussion
Sum valuesintegration account values
Hello,
I'm having trouble adding up the totals in a chart of accounts.
In the chart of accounts, I have integration accounts (DR), intermediate accounts (GA) and transaction accounts (GM), the transaction accounts are the only ones that have a value, but I needed the integration and intermediate accounts to be totalizers of the transaction accounts, how can I do this calculation?
Can you help?
Seems you have relevant information to build a ragged parent-child hiearchy. Essentially you'll need to build your table into this structure instead:
Follow Imke's guide on how to transform your table and you should be good to go:
3 Replies
As long as you have the proper Chart of Accounts (CoA) hierarchy, you should be able to aggregate and get the sum at each level. Also, you may want to use a matrix visual instead.
Can you share a sample of your CoA table?
Hi hnguy71
This is the CoA, I tried to aggregate by level, but I still couldn't do it.
AccountID GroupingCategory GroupingCode Valor 12 GR 12001 GM 12 100 12002 GM 12 200 12003 GM 12 300 12004 GM 12 400 12005 GM 12 500 12006 GM 12 600 12007 GM 12 700 12008 GM 12 800 12010 GM 12 900 12011 GM 12 1000 12012 GM 12 1100 13 GR 131 GA 13 131003 GM 131 100 21 GR 211 GA 21 2111 GA 211 21111 GA 2111 211110002 GM 21111 100 211110011 GM 21111 200 211110041 GM 21111 300 211110055 GM 21111 400 211110070 GM 21111 500 211110071 GM 21111 600 211110075 GM 21111 700 211110076 GM 21111 800 211110078 GM 21111 900 211110080 GM 21111 1000 211110081 GM 21111 1100 211110082 GM 21111 1200 2114 GA 211 21141 GA 2114 211410001 GM 21141 100 211410056 GM 21141 200 211410304 GM 21141 300 211410305 GM 21141 400 218 GA 21 2181 GA 218 21811 GA 2181 218110011 GM 21811 100 218110055 GM 21811 200 22 GR 221 GA 22 2211 GA 221 22111 GA 2211 221110006 GM 22111 100 221110007 GM 22111 200 221110010 GM 22111 300 221110011 GM 22111 400 22112 GA 2211 221120169 GM 22112 100 221120273 GM 22112 200 221120447 GM 22112 300 221120512 GM 22112 400 221120595 GM 22112 500 221120656 GM 22112 600 221120682 GM 22112 700 221120746 GM 22112 800 22113 GA 2211 221130725 GM 22113 100 2214 GA 221 22141 GA 2214 221410001 GM 22141 100 221410003 GM 22141 200 225 GA 22 2251 GA 225 22511 GA 2251 225110053 GM 22511 100 225110069 GM 22511 200 225110071 GM 22511 300 225110171 GM 22511 400 225110342 GM 22511 500 225110461 GM 22511 600 225110467 GM 22511 700 225110563 GM 22511 800 225110695 GM 22511 900 225110712 GM 22511 1000 22512 GA 2251 225120447 GM 22512 100 2254 GA 225 22541 GA 2254 225410003 GM 22541 100 23 GR 231 GA 23 2311 GM 231 100 2312 GM 231 200 232 GA 23 2322 GM 232 100 238 GA 23 2382 GA 238 238201 GM 2382 100 24 GR 241 GA 24 2411 GA 241 24111 GM 2411 100 2412 GA 241 24121 GM 2412 100 24122 GM 2412 200 2413 GA 241 24131 GM 2413 100 24132 GM 2413 200 24133 GM 2413 300 2415 GM 241 400 2416 GM 241 500 242 GA 24 2421 GA 242 24211 GM 2421 100 2422 GA 242 24221 GM 2422 100 2423 GA 242 24232 GA 2423 242322 GA 24232 2423221 GM 242322 100 2424 GA 242 24241 GA 2424 242411 GM 24241 100 24242 GA 2424 242421 GM 24242 100 243 GA 24 2432 GA 243 24321 GA 2432 243211 GA 24321 2432111 GA 243211 243211106 GA 2432111 2432111061 GA 243211106 24321110611 GM 2432111061 100 2432112 GA 243211 243211213 GA 2432112 2432112131 GA 243211213 24321121311 GM 2432112131 100 2432113 GA 243211 243211323 GA 2432113 2432113231 GA 243211323 24321132311 GM 2432113231 100 2432113232 GA 243211323 24321132321 GM 2432113232 100 24322 GA 2432 243221 GA 24322 2432211 GA 243221 243221106 GA 2432211 2432211061 GA 243221106 24322110611 GM 2432211061 100 2432211062 GA 243221106 24322110621 GM 2432211062 100 24322110671 GM 2432211061 200 2432212 GA 243221 243221213 GA 2432212 2432212131 GA 243221213 24322121311 GM 2432212131 100 2432212132 GA 243221213 24322121321 GM 2432212132 100 24322121371 GM 2432212132 200 2432213 GA 243221 243221323 GA 2432213 2432213231 GA 243221323 24322132311 GM 2432213231 100 2432213237 GA 243221323 24322132371 GM 2432213237 100 24323 GA 2432 243231 GA 24323 2432311 GA 243231 243231106 GA 2432311 2432311061 GA 243231106 24323110611 GM 2432311061 100 2432312 GA 243231 243231213 GA 2432312 2432312131 GA 243231213 24323121311 GM 2432312131 100 2432312132 GA 243231213 24323121321 GM 2432312132 100 2432312139 GA 243231213 24323121391 GM 2432312139 100 2432313 GA 243231 243231323 GA 2432313 2432313231 GA 243231323 24323132311 GM 2432313231 100 2432313232 GA 243231323 24323132321 GM 2432313232 100 2432313237 GA 243231323 24323132371 GM 2432313237 100 2432313239 GA 243231323 24323132391 GM 2432313239 100 243231390 GA 2432313 2432313901 GA 243231390 24323139011 GM 2432313901 100 2433 GA 243 24331 GA 2433 243311 GA 24331 2433111 GA 243311 24331111 GA 2433111 2433111106 GA 24331111 24331111061 GM 2433111106 100 24331113 GA 2433111 2433111323 GA 24331113 24331113231 GM 2433111323 100 243312 GA 24331 2433121 GA 243312 24331211 GA 2433121 2433121106 GA 24331211 24331211061 GM 2433121106 100 24331212 GA 2433121 2433121213 GA 24331212 24331212131 GM 2433121213 100 24331213 GA 2433121 2433121323 GA 24331213 24331213231 GM 2433121323 100 243313 GA 24331 2433131 GA 243313 24331311 GA 2433131 2433131106 GA 24331311 24331311061 GM 2433131106 100 24331312 GA 2433131 2433131213 GA 24331312 24331312131 GM 2433131213 100 24331313 GA 2433131 2433131323 GA 24331313 24331313231 GM 2433131323 100 243314 GA 24331 2433141 GA 243314 24331411 GA 2433141 2433141106 GA 24331411 24331411061 GM 2433141 100 24331412 GA 2433141 2433141213 GA 24331412 24331412131 GM 2433141213 100 24331413 GA 2433141 2433141323 GA 24331413 24331413231 GM 2433141323 100 24336 GA 2433 243361 GA 24336 2433611 GA 243361 24336113 GA 2433611 2433611323 GM 24336113 100 243362 GA 24336 2433621 GA 243362 24336211 GA 2433621 2433621106 GM 24336211 100 24336212 GA 2433621 2433621213 GM 24336212 100 243363 GA 24336 2433631 GA 243363 24336312 GA 2433631 2433631213 GM 24336312 100 24336313 GA 2433631 2433631323 GM 24336313 100 24337 GA 2433 243372 GA 24337 2433721 GA 243372 2433721106 GM 2433721 100 24337212 GA 2433721 2433721213 GM 24337212 100 24337213 GA 2433721 2433721323 GM 24337213 100 Seems you have relevant information to build a ragged parent-child hiearchy. Essentially you'll need to build your table into this structure instead:
Follow Imke's guide on how to transform your table and you should be good to go:
