4 Replies Latest reply on Apr 13, 2018 6:17 AM by Branden Kornell

    Count number of conditions met and subtract from other variable

    yegor.tchitaev

      Hi I'm trying to count the number of conditions met (via series of IF conditions) and subtract that from another variable.

       

      [Interval] -

      SUM(

      IF ([Received]<#12/11/2017# and [Actioned]>#07/11/2017#) THEN 1 ELSE 0 END)

      IF ([Received]<#12/03/2018# and [Actioned]>#12/03/2018#) THEN 1 ELSE 0 END)

      ...

      )

       

      It's giving me a syntax error. Wondering if possible, how? Thanks.