Sum Function - doubling the results

[jerryr125]

Hi - I am using the following expression to determine the maximum date for a KPI.

SUM({<[CDC_Vac_Date.autoCalendar.Date]={'$(=Max([CDC_Vac_Date.autoCalendar.Date]))'}>}people_fully_vaccinated)

For some reason the KPI is displaying double the amount - any thoughts - see below - thanks - Jerry

The KPIs should display 4,724,261 and 6,793,934 respectively based upon the filters below.

- Jerry

[JuanGerardo]

Hi @jerryr125, the most probable answer is you have your data duplicated, maybe for location or vac_state with null values (and I suppose those don't show in the table).

Have you tried the same expression you are showing in the table?

SUM({<[CDC_Vac_Date.autoCalendar.Date]={'$(=Max([CDC_Vac_Date.autoCalendar.Date]))'}, vac_state={'PA'},  location={'Pennsylvania'}>} people_fully_vaccinated)

JG