Skip to main content

10 replies

venkatrea696188
January 23, 2024

AFAIK  there isn't such function , Check is there any plug ins available (I don't think there is any Plugins too). Can we know why do wanna convert , So we can think of other ways

tomj8549Author
January 23, 2024

currently doing a columnChartField() and would like shorten the value on the amount to Thousand/Million symbol on the a!measure formatValue as well as the Y-axis

venkatrea696188
January 23, 2024

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

konduruc733182
January 23, 2024

Hello tomj8549,

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.

amaans4178
January 23, 2024

we can write our own logic but  in case if value is : 968546729, what do you expect in output?

venkatrea696188
January 23, 2024

Can't we use round function and use keywords like "Nearly" , "Over"  

amaans4178
January 23, 2024

yes we can but it is not clear from OP.

harshitb6843
January 23, 2024

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
)