Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

SOLVED

How to remove decimal and trailing zeroes for obscure currencies?

TingZilla
Level 2
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
Magus069
Correct answer by
Level 10
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
Magus069
Correct answer by
Level 10
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