topic Sum Function - doubling the results in App Development

Sum Function - doubling the results

jerryr125 — Wed, 12 May 2021 11:43:30 GMT

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

Re: Sum Function - doubling the results

JuanGerardo — Wed, 12 May 2021 12:16:12 GMT

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)