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)
)
