How to remove decimal and trailing zeroes for obscure currencies?

[TingZilla]

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

[Magus069 · Accepted solution]

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

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

[TingZilla]

That works perfectly! Thanks!