3 Replies Latest reply: Jun 13, 2018 9:01 AM by Anthony Richardson RSS

    Count expression disregarding filters

    Anthony Richardson

      I have a data set that spans multiple years and i need an expression that ignores any filters, but i need to apply conditions to the entire data set.

      this expression works with the filter, but i need to applly this across the entire dataset

       

       

      Count(If((Mid([PIID], 10, 1) <> 'G')

      and ([Base And Alloptions Amnt] > 500000 and [Base And Alloptions Amnt] <=2500000)

      and ([Mod Number] = 0)

      and ([Contr Office ID] <> left ([RefIDV PIID], 6)), [Contr Office ID]))