Hello,
I have created a custom currency display type that follows the Canadian French formatting rules (e.g., 1 234,56 $).
In my underlying query, this column is a calculated field and its Data Type is explicitly set to Float.
In my Data View, the Display Type for this column is set to my custom display type (CADfrca).
When a user clicks on the sorting icon in the Data View column header, the rows are sorted alphabetically (as text) rather than numerically.
Is there a way to keep the custom visual formatting while forcing the Data View to sort by the underlying numeric (Float) value?
Thank you!
Jean
Hi Jean,
Thanks for bringing this scenario to our attention and for the details.
The settings you described seem to be correct.
I have sent it to our Development Team for further investigation.
Regards,
Elton S
1 Like
Hi Elton,
I just find out that this issue has already been raised in Sorting on Data Views BUG!
Regards,
Jean
Hi Jean,
We had fixed it, but it seems to be back again due to a few changes we have made.
Regards,
Elton S
1 Like
Hi Jean,
Your latest account upgrade should have the fixes for this issue.
Can you please try again and let me know how that goes?
Thank you.
Elton S
Hi Elton,
It works fine. I tried with my custom currency and the column is now sorted numerically as expected. Thanks!
