4 Replies Latest reply: Mar 19, 2018 11:21 AM by Michael Gauntlett RSS

    Sum(if(

    Michael Gauntlett

      Hi Guys,

       

      I have

       

      SUM(IF((IF(IsNull(AARO_Booking_Period) and IsNull(Status),'R0',If (IsNull(Status),'R1',Status)))='R0',1,0))

       

      which sums the total for a set tollgate in this case R0 as underlined.

       

      the R tollgate will either come from the IF statement:

       

      IF(IsNull(AARO_Booking_Period) and IsNull(Status),'R0',If (IsNull(Status),'R1',Status))

       

      or from the Status field itself.

       

      This works for R0 and R1 when I change the underlined but not for any other.

       

      I have tried sum(IF(Status='R2' etc. but this also does not work any Ideas?

       

      As always greatly appreciated.