Skip to main content

10 replies

venkatrea696188
venkatrea696188
Inspiring
Jan 23, 2024 4:58 AM UTC

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
New Participant
Jan 23, 2024 5:02 AM UTC

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
venkatrea696188
Inspiring
Jan 23, 2024 5:05 AM UTC

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

konduruc733182
konduruc733182
Inspiring
Jan 23, 2024 5:13 AM UTC

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
amaans4178
Brainy
Jan 23, 2024 5:21 AM UTC

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

venkatrea696188
venkatrea696188
Inspiring
Jan 23, 2024 5:28 AM UTC

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

amaans4178
amaans4178
Brainy
Jan 23, 2024 5:53 AM UTC

yes we can but it is not clear from OP.

harshitb6843
harshitb6843
Brainy
Jan 23, 2024 5:56 AM UTC

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
)

    Terms & ConditionsAccessibility statement