The tag has no wiki summary.

learn more… | top users | synonyms

1
vote
1answer
17 views

Currency Data in a Workflow variable rounds to nearest dollar, want to have cents, too

I have one list called Capital Projects with Orig Budget, Amount Spent, Amount Left. I have another list with invoices with Invoice number and TotalAmount. I wrote a workflow that runs every time an ...
1
vote
2answers
152 views

Display “NaN” instead percentage value

I'm using SharePoint 2007 and developing a custom view using SharePoint Designer 2007. I've a column of a table that should display numbers as percentage. Minimun value is 0, maximum 100. In SP ...
0
votes
0answers
40 views

Calculated Column returns excessive amount of zeros

In a Purchase Order form I'm putting together, I have line amount and total amount as calculated columns. However, when displayed in the InfoPath form, they show with a ridiculous amount of zeros at ...
0
votes
1answer
25 views

Making a number of items in one list by the entered value in another list

I have two lists. In one list I have a variable that is a number. When I put certain number (for an example 5) in that variable, I want to make that many (in this case 5) items in another list. The ...
0
votes
0answers
54 views

Edit Integer SPField value in Microsoft Word

I added an two Integer SPField type to a document library: Started and Finished to indicate the year when two events took place with a given document. I did this over the standard number column as an ...
0
votes
1answer
142 views

Programmatically adding a sequence number to the 'Title' column during item creation in SP List

As per the title above, I have a list that stores IT support requests. I need a sequence number that matches with the item ID and I want to add this sequence number to the Title of the request. I ...
0
votes
1answer
149 views

User input issue with Locale change of Site SP 2010

My site is running under SharePoint 2010. Everything is Ok except when I change the locale of my site from Regional settings from US (English) to Malay. The my web part pages where user has number ...
1
vote
2answers
2k views

Creating an Autonumber Column

Is there a way to create an autonumber column in the lists and libraries? For example I want to have a list and when a user wants to add a new value, it automatically generates a new autonumber.
3
votes
1answer
1k views

Converting number field to text field results in data loss

I have the following scenario: A standard generic list with a number column. There is a large number of list items in the list - 200000. All list items have an integer number value (no floating ...
0
votes
1answer
903 views

XSLT for summing Number column where there are cells with no value

This is akin to this question but I couldn't get the suggested sumAll function to work. I also have several different columns to sum and it just seems silly to have a separate template for each ...
2
votes
2answers
139 views

Should I use SharePoint Number column types to store monetary values?

In SharePoint I can create a list column of type 'Number'. I need to store monetary amounts and would like to be able to use this column type rather than having to create a new one. Are values of ...