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