aggregated data counting

[warrentk80]

Goodmorning everyone

I have a table containing names, and the final accounts divided month by month with information whether they have been reviewed or not.
I would need to count the revised accounts as a resource and make the relationship between those reviewed / adjusted and the totals.

attached excel file of example with base date and that and the expressions that I would like to have (columns in yellow)

for the counting of the updated results I tried to use the expression aggr (sum (#Is Adjustment), Resource Full Name) but I extract the lottery numbers 🙂

attached example

thank you all

Andrew

[Or]

This doesn't look like it requires aggr() - a simple sum() will do:

sum(total <[Resource Full Name]> [#Is Adjustment])

(and for the second part):

/count(total <[Resource Full Name]> [#Is Adjustment])