SharePoint Calculated Field Functions and Formulas

Today, I got required to implement a standard deviation in SharePoint list based on other columns and then I thought of use calculated field to do this. So I don't know much what are the functions available and how to implement custom logic for standard deviation. After searching some time in google, I found there is a function STSDEV to do this. Also I find following good links about all functions and formulas that can be used in calculated fields.

http://www.sharepointpanda.com/2009/04/29/sharepoint-calculated-field-functions-and-formulas/

http://msdn.microsoft.com/en-us/library/bb862071.aspx

Comments

Post a Comment

Popular posts from this blog

Switch from Classic to Claims Authentication in SharePoint 2010

SharePoint 2013 tutorials, SharePoint 2010 articles, SharePoint interview questions: Switch from Classic to Claims Authentication in Sh... : In this article we will discuss how to switch from Classic Mode Authentication to Claims Authentication. $webApp = Get-SPWebApplication “http://web application URL/” $webApp.UseClaimsAuthentication = 1 $webApp.Update() $webApp.ProvisionGlobally() $webApp.MigrateUsers($True)
Read more

How to query list data using web service

In SharePoint, to query list data we can also use web services provided by SharePoint other than SharePoint API. We can call web services from two places one is JavaScript and another one is .Net client application. Here I will show you both methods. .Net client application To query list data we will use a web service called lists.asmx . 1. Create .net project either windows/console. 2. Add the web reference and the URL looks like http://<servername:portno>/_vti_bin/lists.asmx 3. Give the web reference name as ListsSvc . 3. Add the following code snippet to get list data. ListsSvc. Lists listService = new  ListsSvc. Lists (); // If the current user is having access you can use below code listService.Credentials = CredentialCache .DefaultCredentials; // In case if you want to pass specific user credentials listService.Credentials = new NetworkCredential ( "<username>" , "<password>" , "<domain>" ); string v...
Read more