If I want to run a report to build a table of data to use in analysis, but the accounts I want to pull are non sequential, whats the best way to do that.
The example half way down this link has a 'From Account' and 'To Account'. Unfortunately I am new to my organization and did not set up the GL. and I have accounts spread out that I want to build reconciliations for using the GIFilter / Velixo-GLDetails.
0 Votes
H
Harry Lewis posted
10 months ago
AdminBest Answer
Hello. Whenever doing a query based on non-contiguous values (such as non-sequential account numbers), each value would need to be specified in the filter you create.
Here is an example for retrieving data for four separate account numbers:
It's important to keep in mind that, if there are too many values, the filter can become so long as to surpass Excel's ability to store the string.
0 Votes
H
Harry Lewisposted
10 months ago
AdminAnswer
Hello. Whenever doing a query based on non-contiguous values (such as non-sequential account numbers), each value would need to be specified in the filter you create.
Here is an example for retrieving data for four separate account numbers:
0 Votes
If I want to run a report to build a table of data to use in analysis, but the accounts I want to pull are non sequential, whats the best way to do that.
The example half way down this link has a 'From Account' and 'To Account'. Unfortunately I am new to my organization and did not set up the GL. and I have accounts spread out that I want to build reconciliations for using the GIFilter / Velixo-GLDetails.
0 Votes
Harry Lewis posted 10 months ago Admin Best Answer
Hello. Whenever doing a query based on non-contiguous values (such as non-sequential account numbers), each value would need to be specified in the filter you create.
Here is an example for retrieving data for four separate account numbers:
0 Votes
3 Comments
Gabriel Michaud posted 10 months ago Admin
Thanks Harry.
Nathaniel, also please note that it's also possible to use the Velixo Range Filtering Syntax and the EXPANDACCOUNTRANGE function to achieve this:
P.S. You can hardcode the connection name and inquiry name in the function if you prefer, like that:
=GIFILTER("Demo","Velixo-GLDetail","Account",EXPANDACCOUNTRANGE("Demo",D3))
0 Votes
Harry Lewis posted 10 months ago Admin
It's important to keep in mind that, if there are too many values, the filter can become so long as to surpass Excel's ability to store the string.
0 Votes
Harry Lewis posted 10 months ago Admin Answer
Hello. Whenever doing a query based on non-contiguous values (such as non-sequential account numbers), each value would need to be specified in the filter you create.
Here is an example for retrieving data for four separate account numbers:
0 Votes
Login or Sign up to post a comment