Timeline for XSLT for summing a column in a Data View Web Part
Current License: CC BY-SA 2.5
6 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jan 19, 2010 at 13:53 | comment | added | noesgard | And yes the decimal format was something I added in an attempt to solve the problem | |
| Jan 18, 2010 at 15:12 | comment | added | Marc D Anderson | Ah, locale joys. You can try the translate function to replace the comma with a period: translate(@Distance, ',', '.'). Is the decimal format line you show above something you added? If not, then removing it might do the trick. | |
| Jan 18, 2010 at 9:06 | comment | added | noesgard | Does not handle negative numbers either... | |
| Jan 18, 2010 at 7:25 | comment | added | noesgard | Think I might have a clue to the cause: The locale is danish and therefore e,g, 3.5 is written: 3,5. SharePoint can handle this and calculates the sum correctly, but 3,5 is not recognized as a number in the xslt... Any ideas how to fix that? (maybe a string replace in the calculation and then again in the representation of the result if possible?) | |
| Jan 18, 2010 at 7:17 | comment | added | noesgard | Still gets NaN on that one :o/ | |
| Jan 15, 2010 at 17:13 | history | answered | Marc D Anderson | CC BY-SA 2.5 |