I have custom data fields in my results grid that categorize my AR data into different timeframes.
I want to sort my data by the “Overdue total” data field, but it does not appear as an option in the sort order dropdown. I’ve tried to copy and paste the same formula into the sort order tab, but the data does not sort correctly.
I have no idea what step I’m missing.
Best answer by andriitkachenko
Hi
I’ve created a quick GI with some data I had nearby. The sorting formula makes no sense, but it shows that it clearly supports formulas:
So I’d suggest looking at your formula. You can troubleshoot it by decomposing it into parts, which you can show as a separate column. And then visually check if there are any problems with showing the value for it.
+4A couple options might be to create a SQL view of this output and then use this in the GI, or it might actually work better as a report.
Check and see if it sorts correctly ungrouped
+11Hi
Please refer to the post below.
https://www.acumatica.com/blog/technical-tuesday-report-from-sql-view/
Best Regards,
NNT
+6Hi
I’ve created a quick GI with some data I had nearby. The sorting formula makes no sense, but it shows that it clearly supports formulas:
So I’d suggest looking at your formula. You can troubleshoot it by decomposing it into parts, which you can show as a separate column. And then visually check if there are any problems with showing the value for it.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
