Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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]))
May be this
Count({1} 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]))
May be this
Count({1} 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]))
maybe this:
Count( {1} 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]))
Again you ROCK!