Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

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

Received Response
61
Views
4
Comments
H Alfaqs
H Alfaqs Rank 3 - Community Apprentice
in Oracle Analytics Cloud and Server

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

Answers

  • Brajesh Shukla-95078
    Brajesh Shukla-95078 Rank 7 - Analytics Coach

    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
    Brajesh Shukla-95078 Rank 7 - Analytics Coach

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

    Could you try the above

  • H Alfaqs
    H Alfaqs Rank 3 - Community Apprentice

    i want to show 5k instead of 5000 in xsl

  • H Alfaqs
    H Alfaqs Rank 3 - Community Apprentice

    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'))"/>