topic Re: Currency Conversion in App Development

Currency Conversion

Usama — Sat, 16 Nov 2024 01:38:21 GMT

Hi,

I have source value as following:

When i am trying to Sum(value). Then getting 0. I know its string for that i have tried Num() & Num#() as well but both not working. When i use Num(Value), all the values in filter pane disappears.

Re: Currency Conversion

lironbaram — Wed, 19 Aug 2020 12:28:23 GMT

this script should help you

load if(index(value,'M')>0,PurgeChar(value,'M')*1000000,value) as value; load PurgeChar(value,'€') as value; Load * Inline [ value €0 €1.1M €1.2M €1.3M €1.4M €1.1M €1.2M €1.1M ];

Re: Currency Conversion

rrsrini2907 — Wed, 19 Aug 2020 14:55:41 GMT

How about this option.

Keepchar(value, '0123456789.')

Little contradicted with the number format. Money is Euro where Decimal places is separate by "," and thousand is separated by "."

Check if above function provide you desired result.

Re: Currency Conversion

Usama — Thu, 20 Aug 2020 12:48:58 GMT

hi,
Its not working. Can you please make me correct if its wrong:

Thanks