How get the sum of ID (id in text)

[Anonymous]

Hello Everyone,


I need urgent help in taking a sum

Currently, I want to find the Sum of ID but the problem is my ID column is in a mixture of numbers and texts so the data type is text

now I want to calculate the sum but I am getting an error that I cannot take the sum of the text which is correct but is there any option through which I can get the sum of the text

[Anonymous]

Hello @Idrissshatila ,
no, I do not want the count, I want the sum

I have a table similar to the above I want to calculate the % which is (id/ sum(id) )*100
then I can get the % column
I want the sum

[Idrissshatila]

Hello @Anonymous ,

You can't sum a text field, do you mean you want to count the IDs ?

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin