Nested Aggregation and Filters

[tomdon14]

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)

)