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


    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.