how to Show number in thousand (k) or in million (M) in xml pulisher

H Alfaqs

Summary

how to Show number in thousand (k) or in million (M) in xml pulisher

Content

hi

how to Show number in thousand (k) or in million (M) in xml pulisher

<xsl:value-of select='format-number(sum (current-group()/PROPOSED1D), "###,###")' />

Thanks

Brajesh Shukla-95078

What is the issue here? Above syntax is fine and it will show data in thousand separator e.g. 1,234,567,676

Brajesh Shukla-95078

<xsl:value-of select="concat(string(format-number(sum (current-group()/PROPOSED1D) div 1000 , '###,###.000')),string('K'))"/>

Could you try the above

H Alfaqs

i want to show 5k instead of 5000 in xsl

H Alfaqs

Thanks Shukla

its working

and this last code

<xsl:value-of select="current-group()/GRP"/>&#160;<xsl:value-of select="concat(string(format-number(sum (current-group()/PROPOSED1D) div 1000 , '###,###')),string('K'))"/>