I have report where I note the account and it’s balance on one row, expand by subaccount on the next
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/9bba840e-9723-4d22-b355-a8cdcbbcaf55.png)
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?
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/9621cdaa-8a33-47ec-ae97-165e75f3bd14.png)
Thanks for any and all help on this!
Best answer by Laura02
View original