Sorting of currency fields in report doesn't work as expected

[bdcitsolutions]

Hello,

we've got an report for the entity "account", with a column "Umsatz" which is the value of a currency field.
As a parameter, this column should be sorted (DESC) but the values don't fit.

The field is

"totalBudget": {
   "type": "currency",
   "required": false,
   "min": 0,
   "readOnly": true,
    "audited": false,
    "tooltip": true,
    "isCustom": true
},

Best, Daniel

Version is ESPO 5.6.11 and Advanced Pack 2.3.14

[yuri]

Hi Daniel,

Can you re-save any of record that is out of order. Maybe the value 'totalBudgetCurrency' is empty in database (should be EUR).

[bdcitsolutions]

This works, thanks Yuri!