Customize group aggregate

Hi all. Im building an accounts application to be used by a company and i dont see an option to customize the group aggregate. For example…

I have a journal entry grouped by Journal Date. I have revenue and expense entry in the same journal view and the aggregate for the day should add all revenue and subtract all expenses and show me the end result as group aggregate.

Your feedbacks are well appreciated in advance…

Thanks & Regards
PrashSuka

Solved Solved
0 2 891
  • UX
1 ACCEPTED SOLUTION

Steve
Participant V

Group aggregates do not support complex functions. As a work-around, consider creating an additional column that contains the desired aggregate values in a summable format: namely, revenue as a positive value and expense as a negative value. Then sum that column for the aggregate.

View solution in original post

2 REPLIES 2

Steve
Participant V

Group aggregates do not support complex functions. As a work-around, consider creating an additional column that contains the desired aggregate values in a summable format: namely, revenue as a positive value and expense as a negative value. Then sum that column for the aggregate.

Thanks Mr. Coile. It worked…

Top Labels in this Space