MOSS Forum

Ask Question   UnAnswered
Home » Forum » MOSS       RSS Feeds

SharePoint list options

  Asked By: Reuben    Date: Jan 10    Category: MOSS    Views: 1196

I've gotten requests to do the following things in a SP list and I'm not sure if
it's possible and if so, how to accomplish it.

1. Calculate the percentage of a column in the record and the sum of all the
record values. So the value would be Column1/Sum(Column2)

2. Only some summary record for the list view.

Is it possible to accomplish this?



6 Answers Found

Answer #1    Answered By: Marianne Vance     Answered On: Jan 10

You can configure the list view to display totals (sums), but I don't think
you can use those values within a calculated field.

Not sure what you mean by #2.

Answer #2    Answered By: Aayushman Kanvinde     Answered On: Jan 10

I was thinking about doing similar kind of stuff the other day. With my limited
sharepoint knowlededge about custom fields, can you please tell if it is
possible for a custom field to refer other fields of the list item or get the
reference to parent list some how in code behind (if there is any).

Answer #3    Answered By: Edgardo Atkins     Answered On: Jan 10

Any calculated field can refer to the other fields in the list item. As for
parent list references in code behind -- my short answer is "yes", but
that's a rather abstract concept. What are you trying to do?

Answer #4    Answered By: Kamal Mayachari     Answered On: Jan 10

running totals or more complex calculations based on other field values, lookups
based on webservice or external data source etc.

Answer #5    Answered By: Kelsie Terrell     Answered On: Jan 10

Try SPServices on CodePlex????????????

Answer #6    Answered By: Alexia Mccarty     Answered On: Jan 10

in #2 I meant to put only show sum totals on the view. I want to
hide all detail.

Didn't find what you were looking for? Find more on SharePoint list options Or get search suggestion and latest updates.