SOLVED

no SUM option in totals, only COUNT.

%3CLINGO-SUB%20id%3D%22lingo-sub-1077663%22%20slang%3D%22en-US%22%3Eno%20SUM%20option%20in%20totals%2C%20only%20COUNT.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1077663%22%20slang%3D%22en-US%22%3E%3CP%3Ehi.%20we%20have%20a%20sharepoint%20list%20that%20is%20using%20a%20powerapps%20form%20for%20entering%20data.%20when%20i%20go%20to%20add%20a%20total%20for%20the%20sharepoint%20list%2C%20it%20has%20no%20SUM%20option%2C%20just%20COUNT.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eis%20there%20a%20way%20to%20show%20the%20sum%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20167px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F162874iAACAA4100F10B11B%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22nosum.png%22%20title%3D%22nosum.png%22%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F162875i94DCCBD6F3D7D6D4%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Screen%20Shot%202019-12-21%20at%2010.06.14%20PM.png%22%20title%3D%22Screen%20Shot%202019-12-21%20at%2010.06.14%20PM.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1077663%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1077738%22%20slang%3D%22en-US%22%3ERe%3A%20no%20SUM%20option%20in%20totals%2C%20only%20COUNT.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1077738%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F436755%22%20target%3D%22_blank%22%3E%40chanpion13%3C%2FA%3E%26nbsp%3Bare%20you%20sure%20it's%20a%20number%20column%20and%20not%20a%20single%20line%20of%20text%20column%3F%20For%20a%20number%20column%20you%20will%20find%20that%20Sum%20is%20available%20whereas%20for%20a%20single%20line%20of%20text%20column%20it%20only%20gives%20the%20Count%20option%20which%20you've%20experienced.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20style%3D%22width%3A%20754px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F162884i8271DE4845ED86D9%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22sum-list-number.png%22%20title%3D%22sum-list-number.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20style%3D%22width%3A%20779px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F162885i1C0EFCA461F9465C%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22sum-list.png%22%20title%3D%22sum-list.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERob%3CBR%20%2F%3ELos%20Gallardos%3CBR%20%2F%3EMicrosoft%20Power%20Automate%20Community%20Super%20User%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1080457%22%20slang%3D%22en-US%22%3ERe%3A%20no%20SUM%20option%20in%20totals%2C%20only%20COUNT.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1080457%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F174092%22%20target%3D%22_blank%22%3E%40Rob%20Elliott%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi.%20It%20is%20a%20Choice%20column%20with%20the%20choices%201%2C2%2C3%2C4%20etc.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20that%20the%20issue%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1080589%22%20slang%3D%22en-US%22%3ERe%3A%20no%20SUM%20option%20in%20totals%2C%20only%20COUNT.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1080589%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F436755%22%20target%3D%22_blank%22%3E%40chanpion13%3C%2FA%3E%26nbsp%3B%20yes%2C%20that's%20the%20issue%3B%20sum%20is%20not%20available%20for%20choice%20columns.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERob%3CBR%20%2F%3ELos%20Gallardos%3C%2FP%3E%3CP%3EMicrosoft%20Power%20Automate%20Community%20Super%20User%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

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?

 

nosum.pngScreen Shot 2019-12-21 at 10.06.14 PM.png

3 Replies
best response confirmed by chanpion13 (Occasional Contributor)
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.

 

sum-list-number.png

 sum-list.png

 

Rob
Los Gallardos
Microsoft Power Automate Community Super User

@RobElliott 

 

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

 

Is that the issue?

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

 

Rob
Los Gallardos

Microsoft Power Automate Community Super User