cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
cyril
Frequent Visitor

Sum() with trailing zero /wrong result based on SharePoint calculated value

Hi

I am completly confused... My sharepoint list has some calculated number columns.

cyril_1-1618987164398.png

 

Imported to Power Apps it looks like this:

cyril_0-1618987048259.png

The values appear correct, they just have many 0 after the decimal point.

 

If I apply a sum() to those numbers it seems the system is not correctly interpreting the decimal point: The result has to be 9 and not 900000000000000.

cyril_2-1618987255934.png

 

Any suggestions how to fix this?

 

1 ACCEPTED SOLUTION

Accepted Solutions
cyril
Frequent Visitor

Found the problem by myself:

 

The problem is the Sharepoint formula:

If it looks like this and the result is a number it doesn't work:

 

=if(Check=true;1;0)

 

But if I use this formula with a text output, it works fine

=if(Check=true;"1";"0")

 

View solution in original post

3 REPLIES 3
cyril
Frequent Visitor

I think the problem is the "." as a decimal point. It should be a comma!

If I add an other row in sharepoint as "number" (DeleteMezahle) it look like this in Power Apps and Sum() is working correctly:

cyril_0-1618989107494.png

But how can I change this format in a calculated column? Or can I replace the "." with a "," somehow?

cyril
Frequent Visitor

Found the problem by myself:

 

The problem is the Sharepoint formula:

If it looks like this and the result is a number it doesn't work:

 

=if(Check=true;1;0)

 

But if I use this formula with a text output, it works fine

=if(Check=true;"1";"0")

 

View solution in original post

Hi @cyril,

So glad that you have solved your problem.

Regards,

Qi

Best Regards,
Qi

Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Top Kudoed Authors
Users online (1,037)