KPI showing wrong count

[kiranb13]

 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 ?

[chrismarlow]

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.