Expand my Community achievements bar.

Guidelines for the Responsible Use of Generative AI in the Experience Cloud Community.
SOLVED

How to remove decimal and trailing zeroes for obscure currencies?

Avatar

Level 2

I am working on layouts for my company's quoting system. We quote products globally.

I'm doing fine with major currency formatting, but Korean currency has me stumped.

I need to remove the decimal and trailing two zeros if the currency is Korean.

I have tried the following using FormCalc:

if (subform_Hidden.Currency.rawValue == "KRW") then

      Format("$zzz,zzz,zz9", sub_PriceSummary.ItemsTotal.TotalOfAll.ZZTotalValue.rawValue)

endif

and

if (subform_Hidden.Currency.rawValue == "KRW") then

     sub_PriceSummary.ItemsTotal.TotalOfAll.ZZTotalValue.rawValue = Format("$zzz,zzz,zz9",      sub_PriceSummary.ItemsTotal.TotalOfAll.ZZTotalValue.rawValue)

endif

Neither work.

I suspect my issue is in the way I'm trying to specify the format, but I cannot find much documentation on how the pattern specification works.

Any help much appreciated! Thanks in advance.

Janet

1 Accepted Solution

Avatar

Correct answer by
Level 10

To change to format (display) pattern you need to change it's picture like this

$.format.picture.value = "num{$zzz,zzz,zz9}"

View solution in original post

2 Replies

Avatar

Correct answer by
Level 10

To change to format (display) pattern you need to change it's picture like this

$.format.picture.value = "num{$zzz,zzz,zz9}"