Forum Discussion

chanpion13's avatar
chanpion13
Copper Contributor
Dec 22, 2019
Solved

no SUM option in totals, only COUNT.

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?

 

  • 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

  • RobElliott's avatar
    RobElliott
    Silver Contributor

    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

      • RobElliott's avatar
        RobElliott
        Silver Contributor

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

         

        Rob
        Los Gallardos

        Microsoft Power Automate Community Super User

Resources