8 Replies Latest reply on Jul 13, 2018 3:24 PM by Emily Skoraczewski

    Count If Statement

    Emily Skoraczewski

      Hello, I found a formula on a discussion from about 5 years ago, and I used the formula provided, which was for, essentially a Count/Sum If. 

      For some reason, instead of getting a '1', I'm getting a '2' entered in my calculation:


      Count Function: IF [Rapid Check] <= 2 THEN 1 ELSE 0 END

      - Then I applied a Sum to the table calculation


      Rapid Check Formula:

      IIF([Status Changed To Hold Auth At] > [Asset Checked In At], DATEDIFF('minute',[Asset Checked In At],[Status Changed To Hold Auth At]),Null)/60




      Why am I getting a 2, not a 1?  I'm so confused!