Hi everyone.
This is my first post here, so please bear with me!
We currently have the latest Jet Reports, and using the GL functions I'm trying to set a filter on a set of segments, but exclude a range within them.
For example, the range reads: 1000..9000 ,and I would like to exclude segment ranges 2500, 4200 and 7800 within the total.
Is there a way of doing this? Everything I have tried from the Jet help has so far failed…
Thanks!
Q
(EDIT - Forgot to add, this is via Dynamics Great Plains, and using the GL functions).
Date
Votes
3 comments
-
Jet Reports Historic Posts Hi Quagmire,
I would try a filter of
"1000..9000&<>2500&<>4200&<>7800" -
Jet Reports Historic Posts Thanks Chuck, I'll give that a try now.
One other problem I'm experiencing is excluding certain account numbers when a segment range is specified.
Using the range above we often have issues where the segment 3 range may be 1000..5000 for example, but we need to exclude a couple of dozen indivudual accounts. They may be: x-xxx-1004.xxx.xxx, x-xxx-2301-xxx-xxx etc.
Our old reporting software had the 'And Not' function, but Jet doesn't it seems.
Trying to do the account exclusion in Jet I get the message that I can only use a segment or account filter - not both.
Is there a way around this?
Thanks again!
Q -
Jet Reports Historic Posts I think this will do the job:
NP("Join";NP("Difference";NL("AllUnique";"G/L Account";"No.";"No.";"1*|2*");NL("AllUnique";"G/L Account";"No.";"No.";"*4|*5"));"|")
or
NL("Rows";NP("Difference";NL("AllUnique";"G/L Account";"No.";"No.";"1*|2*");NL("AllUnique";"G/L Account";"No.";"No.";"*4|*5")))
The first AllUnique gets all accounts starting with 1 or 2, and with the second AllUnique we will exclude the ones ending in 4 or 5.
The NP("Difference") will remove the entries found in the second array from the one in the first array return the result:
{1;2} = NP("Difference";{1;2;3;4};{3;4})
Please sign in to leave a comment.