nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

total aggregation on group not adding up

shamo

I have a report that have figures and grouped. total aggregation at the end doesn't add up. whether on table or group placed in the footer. any idea why this is happening? this is for all the columns

Find more posts tagged with

Comments

micajblock

without the design it is impossible to answer. Can you reproduce with classic models or scripted data set so we can run this?

shamo

I'm unable to replicate based on the data and results. Perhaps an idea can be formed from these screen shots.
Thank you

micajblock

Sorry, no screenshots are of very poor quality. Without the ability to replicate I cannot help.

shamo

Thank you. I resolved it with 2 aggregations. First with aggregation on group using first and then with a sum aggregation on table.