Calculation Condition for KPI

[hammermill21]

Hi,

Today is my day of questions!

I have a KPI that I want it to show only when a date is selected.

The Inspection Date expression is: =Date(Floor([CREATED DATE]), 'MMM DD, YYYY')

The condition I am trying is: =Count(Date(Floor([CREATED DATE]), 'MMM DD, YYYY')) <= 1

But it's not working.

Thanks

[Anonymous · Accepted solution]

building on yours how about

=Count(DISTINCT Date(Floor([CREATED DATE]), 'MMM DD, YYYY')) <= 1

[hammermill21]

YES!! That worked! 

Thank you so very much Wallo