Cannot calculate the Sum

%3CLINGO-SUB%20id%3D%22lingo-sub-2532745%22%20slang%3D%22en-US%22%3ECannot%20calculate%20the%20Sum%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2532745%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20team%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20created%20a%20form%20where%20I%20need%20to%20capture%20the%20total%20time%20spent%20on%20each%20activity.%20However%2C%20on%20the%20file%20under%20the%20total%20time%20I%20see%20an%20extra%20symbol%20before%20the%20number%20(example%3A%26nbsp%3B%3CSPAN%3E'6)%20due%20to%20this%2C%20I'm%20not%20able%20to%20sum%20the%20calculation%20via%20the%20Pivot%20table.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EPlease%20help%20me%20in%20resolving%20this%20issue.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EThank%20you%2C%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3EMahendra%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2532745%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2532984%22%20slang%3D%22en-US%22%3ERe%3A%20Cannot%20calculate%20the%20Sum%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2532984%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1099714%22%20target%3D%22_blank%22%3E%40Mahendrajain%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20can%20Find%20and%20Replace%20the%20extra%20symbols%20with%20Ctrl%20%2B%20H%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22PReagan_0-1625852133284.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F294695i1B903B8D56933E98%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22PReagan_0-1625852133284.png%22%20alt%3D%22PReagan_0-1625852133284.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EOr%2C%20you%20can%20substitute%20extra%20symbols%20like%20'%20with%20%3DSUBSTITUTE(A1%2C%22'%22%2C%22%22)%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22PReagan_1-1625852261611.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F294696i663B545E7B711654%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22PReagan_1-1625852261611.png%22%20alt%3D%22PReagan_1-1625852261611.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hi team,

 

I created a form where I need to capture the total time spent on each activity. However, on the file under the total time I see an extra symbol before the number (example: '6) due to this, I'm not able to sum the calculation via the Pivot table.

 

Please help me in resolving this issue.

 

Thank you,

Mahendra

1 Reply

Hello @Mahendrajain,

 

You can Find and Replace the extra symbols with Ctrl + H:

PReagan_0-1625852133284.png

Or, you can substitute extra symbols like ' with =SUBSTITUTE(A1,"'",""):

PReagan_1-1625852261611.png