cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sabeoleonunes
Helper III
Helper III

Sum of an integer column

Hi all,
I have a excel spreadsheet in SharePoint Document,

sabeoleonunes_0-1599054463716.png

I want to do sum of Yearly Income column using a flow , and the sum should be displayed below it

1 ACCEPTED SOLUTION

Accepted Solutions

@sabeoleonunes 

 

You can add a row to table -

 

CFernandes_0-1599061921989.png

 

Excel Screenshot - 

 

CFernandes_1-1599061955609.png

 

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

 

 

View solution in original post

5 REPLIES 5
ScottShearer
Super User III
Super User III

@sabeoleonunes 

No need for a Flow.  This appears to be a table - just add a totals row to the table from the Table tools ribbon

image.png

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott
CFernandes
Super User III
Super User III

@sabeoleonunes My solution if you want to do it using Power Automate..

 

My Excel - Need total of Count Column.

 

CFernandes_1-1599055820476.png

 

My solution -

 

The Formula in Compose

 

add(int(variables('Column')),int(variables('dummy')))

 

 

CFernandes_0-1599055777471.png

 

After Flow Run - 

 

 

Untitled.png

 

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

 

Hi @CFernandes ,

The flow has run , but the sum is not been seen in the excel file , any solution for that?

 

@sabeoleonunes 

 

You can add a row to table -

 

CFernandes_0-1599061921989.png

 

Excel Screenshot - 

 

CFernandes_1-1599061955609.png

 

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

 

 

View solution in original post

Hi @CFernandes 

Hope you are good.

There was one more approach I was trying 

sabeoleonunes_0-1605697391828.png

So I have this column salary with values in it , 1st I need to calculate the sum and display the result above those values and then add sum with 10% and then display the result above sum, So basically I need to display 2 results the sum as well as sum + 10%.
(I need to display both the results above the data as mentioned in the picture.)

Thanks


 

Helpful resources

Announcements
MPA 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

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

Top Solution Authors
Users online (67,246)