What to do with trailing zeros from SharePointPosted: 2012-08-14
It’s been a long time since the last post, but sometimes one has to take care of things like the family. Ok, so now when that is done we could start having some fun again 🙂
I would like to start with a small and quick one.
Let’s say you have a drop down (field2) in your form that lists objects from a list in SharePoint. The list has got two columns, Title and Number.
The value for the drop down is set to Number and the Display name is set to Title.
Then you need to set another field (field3) in your form to the value of the chosen object,.
Set the Value of field3 to be same as field2
that’s when you will see that the number of the object will have lots of trailing zeros.
An easy way to get rid of these zeros is to insert a formula in front of the field2 value of sum.
this way the zeros will be gone.