how to Show number in thousand (k) or in million (M) in xml pulisher
hi
<xsl:value-of select='format-number(sum (current-group()/PROPOSED1D), "###,###")' />
Thanks
What is the issue here? Above syntax is fine and it will show data in thousand separator e.g. 1,234,567,676
<xsl:value-of select="concat(string(format-number(sum (current-group()/PROPOSED1D) div 1000 , '###,###.000')),string('K'))"/>
Could you try the above
i want to show 5k instead of 5000 in xsl
Thanks Shukla
its working
and this last code
<xsl:value-of select="current-group()/GRP"/> <xsl:value-of select="concat(string(format-number(sum (current-group()/PROPOSED1D) div 1000 , '###,###')),string('K'))"/>
