GlideAggregate SUM calculates wrong Sum on Currencie Fields

[Ruihster]

Good Day,

We have a problem with our instance in that the currency is calculated wrong when using GlideAggregate SUM, Platform Analytics Dashboards Data Visualizations, which also use GlideAggregate, or when using Filters on Tables.

We have the currency set to CHF (Swiss francs), and the problem is ServiceNow is printing and using the currency as USD, so like if we have two expenses with the amount set to 50 CHF, the GlideAggregate sum should show 100 CHF, but it shows 125 CHF (it is 125 USD, but ServiceNow shows it as CHF). The same problem is when using a Single Score Widget on Dashboards, it shows as 125CHF instead of 100CHF.

Also, on Filters there is the problem that when using a filter on expense lines like "Amount is greater than or equal to 50 CHF," it doesn't show any expense lines with 50 CHF because the filter is used in USD, so ServiceNow changes it to "Amount is greater than or equal to 62 CHF" in the background and filters expense lines with the wrong amount.

The Following sys_properties where changed in the Instance:

- glide.i18n.single_currency = true

- glide.i18n.single_currency.code = CHF

We heard and observed that it functions flawlessly on other instances, and when we compared the configurations with the other Instace, they appeared to be same.

Therefore, the question is: Is this a known problem on ServiceNow Instances, or is there something we forgot to configure correctly to ensure ServiceNow uses the correct currency ?

I appreciate your answers to my question in advance.

Thanks

[Mark Manders]

How is the system locale set (glide.system.locale)? I had a similar thing with one of our clients who had set everything to Euros, but the system locale was still set to US, so calculations where often shown in dollars.

[Ruihster]

Hey, thanks for your answer.

The "glide.system.locale" is set to "de.CH" (Swiss German) which is a supported locale for Java (which SNOW uses).

Therefore, this Sys_property should be correct.