web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Different Sum() result...

Power Apps

Unanswered

Different Sum() results (Totals) depending on browser language settings

(0) Share

Report

Report

Posted on by Demo4

13

Hi everyone,

I'm facing a very weird problem.

Problem:

I want to build a total for a specific SharePoint list column (calulated based on other columns).

When my browser language settings are set to English, everything works fine. But when I change the browser language settings to German, the formula gets messed up and returns wrong values.

Tech Stuff

My formula: Text(Sum(Source; 'Gesamt'); "#,###.00 €"; "de-De")

Result with English Browser Settings (correct): 1.124.572,61 €

Result with German Browser Settings (not corrcet): 99.300.030.550.000.000,00 €

SharePoint Column 'Gesamt' (Calculated): =Menge*Preis

SharePoint Column 'Menge' (Text)

SharePoint Column 'Preis' (Currency)

The SharePoint calculation for 'Menge' works fine.

Wild guessing:

I know that in SharePoint Online it is not possibly by default to build a total for a calculated column so I expected some problems...

My guess is that SharePoint returns the values differently depending on the language setting and messes up the commas and periods in German, for example.

So is there any way to "convert" the values or tell Power Apps how to handle / sum the values?
Do you have any ideas?

Thanks in advance 🙂

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

Sort by

Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi! I'm currently facing the same problem. I'm wondering if you ever managed to find a solution for this?

Was this reply helpful? Yes No
JatinSaini 428 on at

Like
a
(0)

Report
Copy link

Link copied!
It appears that the issue you are facing is related to the way numbers are formatted in different language settings, leading to incorrect results in your Power Apps formula when the browser language settings are set to German. The problem lies in the way the numbers are represented with commas and periods in different locales.
When the browser language is set to English, the numbers are formatted with periods as decimal separators and commas as thousand separators, which is the standard English representation. However, when the browser language is set to German, the format changes to use commas as decimal separators and periods as thousand separators.
To address this problem and ensure consistent results in your Power Apps formula, you can modify the formula to take into account the different number representations in different language settings. One way to do this is by using the Replace function to replace the commas and periods with the appropriate characters.
Here's a modified version of your formula that should work with both English and German language settings:

Text( Sum( Source; Value( Replace( Replace( 'Gesamt'; "."; // Replace periods with empty string "" ); ","; // Replace commas with periods "." ) ) ); "#,###.00 €"; "de-De" )

This modified formula uses the Replace function to first remove periods and then replaces commas with periods to ensure that the numbers are consistently formatted with periods as decimal separators and commas as thousand separators.
By applying this modification, your formula should provide correct results regardless of the browser's language settings.

Was this reply helpful? Yes No

Join the conversation