on 03-20-2017 8:43 AM
Hello,
In single group I have 2 instances (Trades and Tax), these instances have similar or overlapping values of GL accounts as explained in below screen shot.
I have created these 2 instances in a single group with no error found.
However the report results shows no rows of section for overlapping values. I mean I can see only 'Trades' but no section with 'Tax' even though data exists for these ranges.
Kindly suggest. Thanks
Naoman D
Not entirely sure I understand but you could try this
Create two formula
@Trade
If GL in (100 to 105) or GL in (110 to 115) then 'TRADE' else 'OTHER'
@Tax
If GL in (100 to 103) or GL in (110) then 'TAX' else 'OTHER'
Group on these two formula
Depending on what other data you are showing restrict data selection to the above GL codes
or
In section expert for both Group Headers
Suppress if either formula returns 'OTHER'
Ian
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks Ian,
I agree about we need further extension to differentiate these 2 instances. My requirement is I want the GL accounts falling under these ranges to be present in both (duplicate) instances , here Tax is sub set of Trades so I need all the GL account falling between 100 to 103 grouped under TAX. Also in TRADE these GL accounts should also be present along with additional GL accounts (104 to 105).
Regards,
Naoman D
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
There must be an extension to the codes that differentiate Trade and Tax.
You must use that to group your data, At present the logic you have in the report can not differentiate between Trade and Tax because the GL Accounts you are using are the same.
Ian
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Kindly Suggest
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
81 | |
24 | |
11 | |
9 | |
7 | |
5 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.