Hey, team - I’ve made some mods to the Trial Balance Summary report and have added parameters for a range of Accounts and Subaccounts. The user will generally put in large ranges of accounts (i.e., 1000000 to 1999999) without selecting actual accounts - in other words, account 1000000 may not actually exist. See below - I can have the user simply select actual accounts, but I’m wondering if there is a way to get this to work, even if they select non-existent accounts in the ranges.
When one or both of the high and low values do NOT exist, the report does not yield any output.
By contrast, ensuring that both accounts DO exist, the report does yield an output
I’ve played around with the parameters tab of the Schema builder (removing the view name, changing the Data type, etc.) ...
Along with playing around with the Filters tab, as well, to no avail.
