Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

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.

share|improve this question
add comment

1 Answer

Calculated columns will only work for values in the current item (row) and will not span across the entire list. For displaying a total across multiple items you will need to use a view.

Using the standard view editor within SharePoint you can only do basic SUMs or COUNTs (Under the Totals section of the View editor). To do your more complex calculation you will need to use SharePoint Designer.

share|improve this answer
    
Thanks theChrisKent. I agree with you on first statement. I also found that I could do basic COUNTs and SUM under Totals section of the View Editor.I need to do lil complex calculation using SPD. Any idea on where to start from? –  Nemo Apr 25 '12 at 15:06
2  
@Nemo Sounds like a new question. ;) –  Kit Menke Apr 25 '12 at 15:20
    
@KitMenke, yes a new question. Any help? Thanks. –  Nemo Apr 25 '12 at 16:16
3  
@Nemo - I think Kit meant that you should ask this is a totally new question rather than putting it on the end of this question. –  Ryan Apr 25 '12 at 16:41
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.