Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
building on yours how about
=Count(DISTINCT Date(Floor([CREATED DATE]), 'MMM DD, YYYY')) <= 1
YES!! That worked!
Thank you so very much Wallo