topic Re: AGGR not cooperating in App Development

AGGR not cooperating

wcoleman0908 — Tue, 21 Dec 2021 22:04:53 GMT

The AGGR function is not returning what I thought it should have based on my data. The visual shows 23 which is incorrect. The number should be 276, can anyone see what is happening and why it doesn't work as expected?

I'm sure its me 🙂

The Expression is: aggr(Sum([Student Count]), StudentID, StudentCategoryID)

Re: AGGR not cooperating

dplr-rn — Mon, 19 Oct 2020 20:19:42 GMT

you need another sum around the aggr.

Aggr essentially returns a table with the value there so in your case it returns

StudentID, StudentCategoryID, Sum([Student Count])

what are the other dimensions in your chart?

Re: AGGR not cooperating

wcoleman0908 — Mon, 19 Oct 2020 20:42:25 GMT

There is a category field, and a category Code field as other dimension. So what would the New AGGR STATEMET LOOK LIKE?

Old: AGGR(Sum([Student Count]), StudentID, StudentCategoryID)

New: ?

Re: AGGR not cooperating

dplr-rn — Mon, 19 Oct 2020 20:46:10 GMT

Sum(AGGR(Sum([Student Count]), StudentID, StudentCategoryID) )

i dont see category code field in your excel

Re: AGGR not cooperating

wcoleman0908 — Mon, 19 Oct 2020 20:51:49 GMT

No sorry it was test data but i added the update you suggested and it now works properly.

Thanks buddy