NL(SUM) for range of accounts in Dynamics GP

Hi I have a unique problem here. People here want to look at the YTD Balance for credits and debits. if i have an account number (Example 1000-1000000) i can use a NL(SUM) to pull it from the db like this. All i need is another column to get the account index and then use it as one of the filters.


How do I do something similar to this if there are a range of account numbers? I want the sum of all the accounts in that range.? (Example 1000-*******)



Please sign in to leave a comment.