Good morning community,
I have been asked on the Transactions for Period report to set up the parameter to be able to search by the last 6 numbers of the subaccount ID.
I have tried adding “Left” in the formula and 6 at the end and that is not working on the parameters or the formula field.
Any best practices to get this to work?
Thank you in advance for any pointers!
Thank you,
Trisha
+4
Hi
If the first six will always be zero, then you can enter in Default Value field =’000000’:
Then on the report screen just press F3 on the blank part and it will bring up selector for last segment.
The expression won’t be able to limit the subaccount field to a certain amount of characters, unless it was customized.
+18
Hello
Have you tried leaving the subaccount blank on the parameters tab and using “Contains” in the Additional Filtering Conditions?
Laura
I haven’t tried using the additional filters. The group that is asking for this update might not have been shown this feature. I will talk to the manager that is asking for this.
I will look at this option as well.
Thank you BOTH for your ideas!
Trisha
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
