Answered

Internet Explorer calculates differently

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hey Guys,

I am using a Round function :
Round( (ThisItem.Progress1 + ThisItem.Progress2 + ThisItem.Progress3 + ThisItem.Progress4) / ThisItem.NumberOfStand) *100 , 0)

In the example the numbers are: (0.75 + 0.5 + 0.6 / 3 ) * 100

In the Interpet Explorer it calculates the following overall progress:

But the Chrome Brwoser calculates it correctly with: 62%

BildPRoblem%.PNG

Can I somehow tell PowerApps to seperate the function for different Browsers?

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

CarlosFigueira Microsoft Employee on at

Like (2)

Report
Copy link

Link copied!
What are the types of the values 'Progress1', 'Progress2', 'Progress3' and 'Progress4'? If they are of type text, then PowerApps will try to convert them to numbers based on the rules of the current locale prior to adding them up. Chrome and IE have different ways of determining the current locale (Chrome is based on one of its settings, IE is based on the OS's language settings), which could explain the difference.

If the values are indeed text, and you know that its decimal separator is the '.', you can indicate to the expression the locale that you want to use the conversion using the Value function:

Round( ( Value(ThisItem.Progress1, "en-US") + Value(ThisItem.Progress2, "en-US") + Value(ThisItem.Progress3, "en-US") + Value(ThisItem.Progress4, "en-US")) / ThisItem.NumberOfStand * 100, 0)

Hope this helps!

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Thank you @CarlosFigueira,
unfortunaltely its not the solution. If I change it to your code the progress in IE is : 0.
The Progress1-4 are columns in a sharepoint list which are calculated with numbers from different columns and formatted to percentage in the sharepoint list.

Was this reply helpful? Yes No
v-yutliu-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @Anonymous ,

I've made a similar test in IE and not met the same problem like your description.

Here's my test:

set the label's Text:

Round((0.75 + 0.5 + 0.6)/3*100,0)

And the label display "62".

So the caoculation and Rond function in IE has no problem.

I think the problem is your column's Value.

Could you make sure that :ThisItem.Progress1,ThisItem.Progress2,ThisItem.Progress3,ThisItem.Progress4 and ThisItem.NumberOfStand display as "0.75 ,0.5 , 0.6, 3" in IE?

Since they are calculated fields and formatted to percentage, so it may has some problems in displaying.

Please check this. If they do not display as "0.75 ,0.5 , 0.6, 3", I suggest you transfer them before calculating.

I've found some has met the similar issue, he used this to transfer:

Concatenate(Text(Round(Value(ThisItem.CompletionScore)*100,0),"[$-en-US]0"),"%")

https://powerusers.microsoft.com/t5/Building-PowerApps-Formerly/Show-a-percentage-from-Sharepoint-list/td-p/96949

Best regards,

Was this reply helpful? Yes No
Verified answer

Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Your first answer was almost correct, I just needed to use the value funktion for the NumberOfStand as well.
So this worked:

ound( ( Value(ThisItem.Progress1, "en-US") + Value(ThisItem.Progress2, "en-US") + Value(ThisItem.Progress3, "en-US") + Value(ThisItem.Progress4, "en-US")) / Value(ThisItem.NumberOfStand, "en-US") * 100, 0)

Was this reply helpful? Yes No