Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Divide amount by 1000 and change the number format like:
Num( if(Flag='US',Sum(Uvol), Sum(Ivol)) /1000 , '#,##0K' )
just write
if(Flag='US',Sum(Uvol), Sum(Ivol)) & 'K'
NUM( if(Flag='US',Sum(Uvol), Sum(Ivol)),'#,##0K')
You can write this way
=Num( if(Flag='US',Sum(Uvol), Sum(Ivol))
,'#,##0K' )
Divide amount by 1000 and change the number format like:
Num( if(Flag='US',Sum(Uvol), Sum(Ivol)) /1000 , '#,##0K' )
=NUM(YourExpression/1000,'#,##0K')
if(Flag='US',num(Sum(Uvol)/1000,'#,##0K'), num( Sum(Ivol)/1000,'#,##0K'))
Thanks for your quick help.