I have report where I note the account and it’s balance on one row, expand by subaccount on the next
row set example
This is working great for obtaining the subaccount activity that makes up the account balance. However when printing the report, I would like to sort the subaccount string numerically. Currently, segment one is sorting largest to smallest while segment 2 is smallest to largest. Does anyone know of a custom expression for either the column set or row set to be able to sort the string smallest to largest?
example of report output (exported to Excel), same behavior in the Acumatica screen and when exporting to PDF
To Sort smallest to largest, you want to sort Ascending, not Descending. (Remove D from formula.)
Your row number where the subaccounts are expanded is 1145.
Subaccount is located in the first column, Description column of the report, yes? if so, The first column on the report is column A and therefore your Sort formula is =SORT(‘1145’,’1145’,’A’)
To Sort smallest to largest, you want to sort Ascending, not Descending. (Remove D from formula.)
Your row number where the subaccounts are expanded is 1145.
Subaccount is located in the first column, Description column of the report, yes? if so, The first column on the report is column A and therefore your Sort formula is =SORT(‘1145’,’1145’,’A’)
Thank you both! Yes, Laura, I simplified down to your formula for Ascending order and this works beautifully. I looked at D also but that is descending and I needed Ascending. And, sorted on Column A because that is the column the accounts, subaccounts and description live in. Here is the added row for this example.
We use 3 different kinds of cookies. You can choose which cookies you want to accept. We need basic cookies to make this site work, therefore these are the minimum you can select. Learn more about our cookies.
