This content has been marked as final. Show 3 replies
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]))