KPI showing wrong count

kiranb13 — Mon, 20 Dec 2021 21:08:46 GMT

Hi Team,

Below is the scenario.

Expression in table :

=If(Date([Consumption Date])=Date([Scheduled Date]),Date([Scheduled Date]))

Expression in KPI:

=sum(If(Date([Consumption Date])=Date([Scheduled Date]),1))

There are 12 records in table. But in KPI i am getting the value as 36. I tried with count expression as well.

=count(If(Date([Consumption Date])=Date([Scheduled Date]),Date([Scheduled Date]))

Can anyone help me out here with the correct expression to get value as 12 ?

Re: KPI showing wrong count

chrismarlow — Thu, 06 Aug 2020 19:13:00 GMT

Hi,

I think you must have multiple records with same combination of the 3 fields (which may or may not be right) for your KPI to stop counting the duplicates try;

=count(distinct If(Date([Consumption Date])=Date([Scheduled Date]),[Scheduled Date]))

Cheers,

Chris.

topic Re: KPI showing wrong count in App Development

KPI showing wrong count

Re: KPI showing wrong count