Calculation error in Datasheet view in SharePoint

Posted by Marius on Stack Overflow See other posts from Stack Overflow or by Marius
Published on 2010-03-26T19:44:04Z Indexed on 2010/04/08 18:43 UTC
Read the original article Hit count: 224

Filed under:

sharepoint2007

|

calculation

|

calculated-columns

I have a custom list, with calculation, in SharePoint. Everything worked fine until recently when the DataSheet will show strange or wrong % calculation in a % column. But the Standard View will show correct values. IT checked the server side and everything looked ok, I checked the formulas and even re-did them in the column and the issue persist.

Anyone, any suggestion?

Thanks,

© Stack Overflow or respective owner

Related posts about sharepoint2007

Copy Content from Sharepoint2007 to another Sharepoint2007

as seen on Server Fault - Search for 'Server Fault'
Hi There, I have a Sharepoint 2007 web farm installation with two site collections, one is a blank site and the other is a migrated Sharepoint 2003 site collection. I want to move some specific content from the migrated 2003 collection to the 2007 collection, however I also want to change the path… >>> More
SharePoint Server 2007 Stops Responding to External Requests

as seen on Server Fault - Search for 'Server Fault'
We have a SharePoint2007 server running on a Windows Server 2003 Box. The box itself is quite old but has not experienced any weird issues. Recently SharePoint has begun to show some strange behavior. One of the most annoying things is that once in a while, the sharepoint sever stops responding to… >>> More
Good bug tracking with Sharepoint?

as seen on Super User - Search for 'Super User'
At my place of work, it has been decided to move many processes to Sharepoint. I'm now looking into how Sharepoint can be used for bug tracking (à la Mantis, FogBugz etc. but within Sharepoint). Specifically, we're using a collaboration room and the solution must work inside that. I know that I can… >>> More
Sharepoint 2007: author.dll status code?

as seen on Server Fault - Search for 'Server Fault'
Is there a way to find any info using /_vti_bin/_vti_aut /author.dll status code? <html><head><title>vermeer RPC packet</title></head> <body> <p>method= <p>status= <ul> <li>status=393226 <li>osstatus=0 <li>msg=The form… >>> More
IE Tab 2 vs IE Tab Plus

as seen on Super User - Search for 'Super User'
I'm wonder what the differences are, especially as it pertains to SharePoint. Why should I pick one over the other or does it matter? Also are there any Linux browser solutions for SharePoint, besides Wine + IE 6. >>> More

Related posts about calculation

Most efficient sorting of calculation on DataTable column calculation

as seen on Stack Overflow - Search for 'Stack Overflow'
Lets say you have a DataTable that has columns of "id", "cost", "qty": DataTable dt = new DataTable(); dt.Columns.Add("id", typeof(int)); dt.Columns.Add("cost", typeof(double)); dt.Columns.Add("qty", typeof(int)); And it's keyed on "id": dt.PrimaryKey = new DataColumn[1] { dt.Columns["id"] }; Now… >>> More
Calculation Expression Parser with Nesting and Variables in ActionScript

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi There, I'm trying to enable dynamic fields in the configuration file for my mapping app, but I can't figure out how to parse the "equation" passed in by the user, at least not without writing a whole parser from scratch! I'm sure there is some easier way to do this, and so I'm asking for ideas… >>> More
Calculation Conundrum - how do I influence another textfield?

as seen on Stack Overflow - Search for 'Stack Overflow'
Hey! Basically I have a problem in that when certain parameters are used in my calculator app - it makes the result incorrect. The issue is that I have separate text fields for hours and minutes and say for example I have as the start time "13" in one text field and "30" in the other with the finish… >>> More
Stupid Geek Tricks: How to Perform Date Calculations in Windows Calculator

as seen on How to geek - Search for 'How to geek'
Would you like to know how many days old are you today? Can you tell what will be the date 78 days from now? How many days are left till Christmas? How many days have passed since your last birthday? All these questions have their answers hidden within Windows! Curious? Keep reading to see how you… >>> More
HPCM 11.1.2.2.x - HPCM Standard Costing Generating >99 Calc Scipts

as seen on Oracle Blogs - Search for 'Oracle Blogs'
HPCM Standard Profitability calculation scripts are named based on a documented naming convention. From 11.1.2.2.x, the script name = a script suffix (1 letter) + POV identifier (3 digits) + Stage Order Number (1 digit) + “_” + index (2 digits) (please see documentation for more information (http://docs… >>> More