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

User_F21JQ · Jul 30, 2017 3:48PM

hi

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

Thanks

User_F21JQ · Aug 3, 2017 12:32AM

hi

any update ?

Hendrik Schmidt · Aug 3, 2017 1:50AM

Hello,

There is an own XML (BI) Publisher Community.

regards

Thomas Dodds · Aug 4, 2017 8:36AM

Add the manipulations to your query ...

SELECT SALES, (SALES/1000) SALES_K, (SALES/1000000) SALES_M FROM TABLE ... then do your format masking

Oracle Analytics Cloud and Server