Need help in number format

[#1]

Hi All,

      I have strucked in converting the number format, My chart expression is giving the values like 2359526 and my expression for this value is if(Flag='US',Sum(Uvol), Sum(Ivol))  but I need to convert this number to  2,359K (need to add k end of the number). Please suggest me a idea for this.

[alexandros17]

just write

if(Flag='US',Sum(Uvol), Sum(Ivol)) & 'K'

[rustyfishbones]

NUM( if(Flag='US',Sum(Uvol), Sum(Ivol)),'#,##0K')

[its_anandrjs]

You can write this way

=Num( if(Flag='US',Sum(Uvol), Sum(Ivol))

,'#,##0K' )

[tresesco · Accepted solution]

Divide amount by 1000 and change the number format like:

Num( if(Flag='US',Sum(Uvol), Sum(Ivol)) /1000 , '#,##0K' )

[MK_QSL]

=NUM(YourExpression/1000,'#,##0K')

[nizamsha]

if(Flag='US',num(Sum(Uvol)/1000,'#,##0K'), num( Sum(Ivol)/1000,'#,##0K'))

[#8]

Thanks for your quick help.