11 Replies Latest reply: Jul 12, 2017 12:38 PM by Elizabeth Viso RSS

    Calculation Condition for KPI

    Elizabeth Viso



      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.