How to sort a Data View column by numeric value when using a custom Currency Display Type?

How do I?
1

Hello,

I have created a custom currency display type that follows the Canadian French formatting rules (e.g., 1 234,56 $).

image
image487×507 11.5 KB

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.

image
image249×279 6.72 KB

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

2

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
3

Hi Elton,

I just find out that this issue has already been raised in Sorting on Data Views BUG!

Regards,

Jean

4

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