no SUM option in totals, only COUNT.

[chanpion13]

hi. we have a sharepoint list that is using a powerapps form for entering data. when i go to add a total for the sharepoint list, it has no SUM option, just COUNT.

is there a way to show the sum?

[#2 · Accepted solution]

@chanpion13 are you sure it's a number column and not a single line of text column? For a number column you will find that Sum is available whereas for a single line of text column it only gives the Count option which you've experienced.

 

Rob
Los Gallardos
Microsoft Power Automate Community Super User

[#3]

@RobElliott 

Hi. It is a Choice column with the choices 1,2,3,4 etc.

Is that the issue?

[#4]

@chanpion13  yes, that's the issue; sum is not available for choice columns.

Rob
Los Gallardos

Microsoft Power Automate Community Super User