I want to add another part to this count expression to limit a user.
Something like and [User] <> 'MATT' adding into my code:
count({$<[P Description] ={"$(=concat([M Description],'","'))"},
[P C Description] ={"$(=concat([M C Description],'","'))"},
[A exempt] = {'Non-exempt'},[Late P] = {'Late P'}>}
aggr(if([P Created Month Date] >= ($(vToday)-[P Created Month Date]),
count([P Number])),[P Number]))
I have tried:
count({$<[P Description] ={"$(=concat([M Description],'","'))"},
[P C Description] ={"$(=concat([M C Description],'","'))"},
[A exempt] = {'Non-exempt'},[Late P] = {'Late P'}>}
aggr(if([P Created Month Date] >= ($(vToday)-[P Created Month Date]) and [User] <> 'MATT',
count([P Number])),[P Number]))
But this makes no difference.
Aucun commentaire:
Enregistrer un commentaire