Sum of Columns

[deepalsoft]

I have created simple Trial balance using excel data set. But can not get total of DR and CR columns.

Please help to find the solution.

Thanks.

[deepalsoft]

This is a data from model (sample)

Account Date	Code	Account Name	Organization	Account Type	Debit	Credit	Balance
2020-07-02	21100	Accounts Payable Trade	Head Office	Liability	1397	0	1397
2003-01-22	21100	Accounts Payable Trade	Head Office	Liability	0	2731.5	-2731.5
2020-07-02	21100	Accounts Payable Trade	Head Office	Liability	0	1397	-1397
2002-02-22	12110	Accounts Receivable - Trade	Head Office	Asset	50.35	0	50.35
2002-02-22	12110	Accounts Receivable - Trade	Head Office	Asset	100.7	0	100.7
2002-08-01	12110	Accounts Receivable - Trade	Head Office	Asset	161.12	0	161.12
2020-06-11	12110	Accounts Receivable - Trade	Head Office	Asset	42.75	0	42.75
2020-06-14	12110	Accounts Receivable - Trade	Head Office	Asset	427.5	0	427.5
2020-06-14	12110	Accounts Receivable - Trade	Head Office	Asset	47.03	0	47.03
2020-06-14	12110	Accounts Receivable - Trade	Head Office	Asset	470.25	0	470.25
2020-06-19	12110	Accounts Receivable - Trade	Head Office	Asset	-470.25	0	-470.25
2020-06-11	12110	Accounts Receivable - Trade	Head Office	Asset	47.03	0	47.03
2020-06-11	12110	Accounts Receivable - Trade	Head Office	Asset	3.3	0	3.3
2002-02-22	12110	Accounts Receivable - Trade	Head Office	Asset	0	50.35	-50.35
2002-02-22	12110	Accounts Receivable - Trade	Head Office	Asset	0	100.7	-100.7
2020-06-11	12110	Accounts Receivable - Trade	Head Office	Asset	0	42.75	-42.75
2020-06-14	12110	Accounts Receivable - Trade	Head Office	Asset	0	47.03	-47.03
2020-06-14	12110	Accounts Receivable - Trade	Head Office	Asset	0	427.5	-427.5
2020-06-14	12110	Accounts Receivable - Trade	Head Office	Asset	0	470.25	-470.25
2020-06-19	12110	Accounts Receivable - Trade	Head Office	Asset	0	-470.25	470.25
2020-06-19	12110	Accounts Receivable - Trade	Head Office	Asset	0	-470.25	470.25
2020-06-19	12110	Accounts Receivable - Trade	Head Office	Asset	0	470.25	-470.25
2020-06-19	12110	Accounts Receivable - Trade	Head Office	Asset	0	470.25	-470.25
2020-06-19	12110	Accounts Receivable - Trade	Head Office	Asset	0	-470.25	470.25
2020-06-11	12110	Accounts Receivable - Trade	Head Office	Asset	0	47.03	-47.03
2020-06-11	12110	Accounts Receivable - Trade	Head Office	Asset	0	3.3	-3.3

[deepalsoft]

No. It is a calculated column. Here is the source.

[VahidDM · Accepted solution]

Can you share a sample of your file?

BTW, It's because of that IF statement, check this link:

https://www.vahiddm.com/post/why-my-measure-returns-the-wrong-total

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/

[deepalsoft]

This was help to resolve problem.

Many Thanks.

[deepalsoft]

Account Date	Code	Account Name	Organization	Account Type	Debit	Credit	Balance
2020-07-02	21100	Accounts Payable Trade	Head Office	Liability	1397	0	1397
2003-01-22	21100	Accounts Payable Trade	Head Office	Liability	0	2731.5	-2731.5
2020-07-02	21100	Accounts Payable Trade	Head Office	Liability	0	1397	-1397
2002-02-22	12110	Accounts Receivable - Trade	Head Office	Asset	50.35	0	50.35
2002-02-22	12110	Accounts Receivable - Trade	Head Office	Asset	100.7	0	100.7
2002-08-01	12110	Accounts Receivable - Trade	Head Office	Asset	161.12	0	161.12
2020-06-11	12110	Accounts Receivable - Trade	Head Office	Asset	42.75	0	42.75
2020-06-14	12110	Accounts Receivable - Trade	Head Office	Asset	427.5	0	427.5
2020-06-14	12110	Accounts Receivable - Trade	Head Office	Asset	47.03	0	47.03
2020-06-14	12110	Accounts Receivable - Trade	Head Office	Asset	470.25	0	470.25
2020-06-19	12110	Accounts Receivable - Trade	Head Office	Asset	-470.25	0	-470.25
2020-06-11	12110	Accounts Receivable - Trade	Head Office	Asset	47.03	0	47.03
2020-06-11	12110	Accounts Receivable - Trade	Head Office	Asset	3.3	0	3.3
2002-02-22	12110	Accounts Receivable - Trade	Head Office	Asset	0	50.35	-50.35
2002-02-22	12110	Accounts Receivable - Trade	Head Office	Asset	0	100.7	-100.7
2020-06-11	12110	Accounts Receivable - Trade	Head Office	Asset	0	42.75	-42.75
2020-06-14	12110	Accounts Receivable - Trade	Head Office	Asset	0	47.03	-47.03
2020-06-14	12110	Accounts Receivable - Trade	Head Office	Asset	0	427.5	-427.5
2020-06-14	12110	Accounts Receivable - Trade	Head Office	Asset	0	470.25	-470.25
2020-06-19	12110	Accounts Receivable - Trade	Head Office	Asset	0	-470.25	470.25
2020-06-19	12110	Accounts Receivable - Trade	Head Office	Asset	0	-470.25	470.25
2020-06-19	12110	Accounts Receivable - Trade	Head Office	Asset	0	470.25	-470.25
2020-06-19	12110	Accounts Receivable - Trade	Head Office	Asset	0	470.25	-470.25
2020-06-19	12110	Accounts Receivable - Trade	Head Office	Asset	0	-470.25	470.25
2020-06-11	12110	Accounts Receivable - Trade	Head Office	Asset	0	47.03	-47.03
2020-06-11	12110	Accounts Receivable - Trade	Head Office	Asset	0	3.3	-3.3

[VahidDM]

Hi @deepalsoft 

Check those columns format or aggregation of those columns, it seems they have Text format, so change that to whole number 

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/

[Shishir22]

Hello @deepalsoft ,

Please make sure that aggregation is set to "SUM" if you are using direct feilds from table. 

If calculated using measure then please share the measure.

If its solves your issue, please mark it as answer. Kudos are also appreciated.

Thanks,

Shishir