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

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

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 (3,303)