cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Larsvedoy
Helper I
Helper I

Can't sum SharePoint List column - number format issue?

My whole message was deleted... will have to rewrite ...

3 REPLIES 3
v-xida-msft
Community Support
Community Support

Hi @Larsvedoy ,

Could you please share a bit more about your issue?

Do you mean that the Sum function could not work within your SP List column?

 

If you want to sum a Number type column in your SP List, please consider take a try with the following formula:

Sum('SP List', NumberColumn)

or

Sum(
    ForAll(
           'SP List',
           NumberColumn
    ),
    Value
)

 

If you want to sum the Text type column in a SP List, please consider modify above formula as below:

Sum('SP List', Text(NumberColumn))

 

Please provide more details about your issue, then we could provide a proper workaround for you.

 

Best regards,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi @Larsvedoy ,

I have made a response to your new posted thread, please check my response within the following thread:

https://powerusers.microsoft.com/t5/Building-Power-Apps/Sum-a-SharePoint-calculated-column-format-is...

 

If you have solved your problem, please consider go ahead to click "Accept as Solution" to identify this thread has been solved.

 

Best regards,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

secondImage

Power Apps Community Call

Please join us on Wednesday, October 20th, at 8a PDT. Come and learn from our amazing speakers!

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 (2,187)