2 Replies Latest reply on Feb 20, 2013 11:42 PM by Justin Nathan

    If statement with COUNTD not working

    Justin Nathan

      I am trying to calculate the instances where there has been a late report (Past due) and if so how many unique event references exist, by way of a distinct count of the Unique event reference.

       

      I have come up with the formula below however although it is valid it is not returning the expected results.  A screenshot of the relavent section of data is also shown

       

      If ATTR([Past due]) = 'Past due' THEN COUNTD([Unique evref] ) ENDUntitled.jpgent 

      Any help is greately appreciated.

       

       

       

      J