Oracle Analytics Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Analytics Forums› Oracle Analytics Forum

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
71
Views
4
Comments
H Alfaqs
H Alfaqs Rank 3 - Community Apprentice
in Oracle Analytics Forum

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