Answered

Sum of calculated field shows false result

(0) Share

Report

Posted on by hpc1

Dear community,

I made a calculated field in a SharePoint list. Then I created a gallery listing these calculated figures which look okay. However when I make a sum of these Numbers I get a totally wrong result. Screenshot is attached.

What happens here and how can I proceed to get the right result, which should be 3.55?

Thanks for help!

Categories:

Building Power Apps

All responses (4)

Answers (1)

Sort by

Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@hpc1

Don't use calculated fields in SharePoint. Do the calculations in PowerApps and save them to a Number type field in SharePoint.
Verified answer

CU-18081211-6 9,272 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
@hpc1 ,

Try to use ( I hope i'm not mistaken that you are from Germany):

Sum(Gallery8.AllItems,Value(NotenWert,"de"))

Hope it helps !
hpc1 64 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for your reply. I'm from Switzerland. Oddly enough "de" doesn't work but "en" does.
NN-21081740-0 492 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi
Please help.
My issues is almost the same except in my case the app shows a total price instead of the total spend. On my desktop I can see the total spend and the total price but on my phone both fields show total price. I tried recreating the problem field but that didn't solve the problem.