Nested Aggregation and Filters

tomdon14 — Tue, 19 Sep 2023 18:11:21 GMT

Hello –

I’m trying to create a calculation which will display for a specific month (Aug-2022). The calculation uses a nested aggregation. It calculates correctly if “Aug-2022” is selected in the Filter pane. However, if “Aug-2022” is removed from the filter, the calculation results in 0 (zero). Any idea what I am doing wrong? Thanks.

sum({<YearMonth = {'Aug-2022'}>}

Aggr(

sum({<YearMonth = {'Aug-2022'}>}

aggr(

if(FullDate = date(Min({<YearMonth=,COMR_LATENESS_FLAG_LABEL= {'Late'} >} TOTAL <CASE_AER_NUMBER_VERSION> date#(FullDate,'DD-MMM-YYYY') ),'DD-MMM-YYYY')

,1)

,COMR_PROCESS_POINT, CASE_AER_NUMBER_VERSION, FullDate)

)

,YearMonth)

)

topic Nested Aggregation and Filters in App Development

Nested Aggregation and Filters