I could import the excel data shown here to a SharePoint list 2010.I imported all the columns. Let's say I have two columns. Name and Value. For Value column, I have numeric type. I need to calculate Score for Value column, which can be calculated(In EXCEL) as (COUNTA(Value)/Total items in the sheet)*100
How do I calculate this value in SharePoint 2010 list? I tried adding a calculated field but it doesn't allow to use any functions such as COUNT, SUM, AVG etc. It only allows to calculate the values based on other column values.
Can you first create a form out of the list and add all the required fields in the form and for each form field, calculate the formula?
Help is GREATLY appreciated.