Currency Conversion

[Usama]

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.  

[lironbaram]

hi 

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
];

[rrsrini2907]

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.

[Usama]

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

Thanks