Convert numbers to Thousand/Million Symbol

Question

Hi, Is there an existing function on Appian to convert this value for example 100,000 to 100k? this goes on by million or billion. Thanks2

EREN_YEAGER · Answer

yes, by question phrase OP said value can be million or billion, assuming it can go more than number(integer) range in Appian which can be an issue, if it is below than that Yamaken -> /*you can use round funcction to display values after decimal for ex bellow cade will give you 100K for 100000, and 100.543K for 100543 to round up the result by 1 or 2 decimal you can use round function to get desired result e.g - 100.5k*/ if( or(len(ri!number) < 4, len(ri!number) > 10), ri!number, a!match( value: len(ri!number), whenTrue: fv!value < 7, then: concat(ri!number / 1000, "k"), whenTrue: fv!value < 10, then: concat(ri!number / 1000000, "M"), default: concat(ri!number / 1000000000, "B") ) )

Harshit Bumb (Appyzie) · Answer

You can use this customized rule that I created for myself

a!match(
  value: ri!num,
  whenTrue: and(len(fv!value)>=4,len(fv!value)<=6 ),
  then: concat(round(fv!value/1000,2),"k"),
  whenTrue: and(len(fv!value)>=6,len(fv!value)<=9 ),
  then:concat(round(fv!value/1000000,2),"m"),
  whenTrue:len(fv!value)<=9,
  then: concat(round(fv!value/10000000,2),"b"),
  default: fv!value
)

venkat Avuluri · Answer

Then Why don't you divide the value with million and just Add "in Millions" Tag.

Konduru Chaitanya · Answer

Hello Yamaken , There is no such function to perform your requirement. We have currency function to get the format from normal text/numbers to ISO formats but not from ISO format to the way you are expecting. May be you can create a generic rule and use along your application instead as it is a very minor and easy to handle requirement.

Convert numbers to Thousand/Million Symbol

Top Replies