SharePoint

If you’re having trouble with format-number function in XSLT data view – it’s probably because of decimal comma. The server returns data with decimal comma, and the format-number function works with decimal dot. The workaround is to translate the values <xsl:value-of select="format-number(translate(translate(@NumberField,’.’,’,’),’,’,’.’), ‘#.##0,00;-#.##0,00′, ‘lcid1060′)" /> (in the example above the @NumberField represents the internal name [...]