Number format

[cmutombo]

Hi Communauty, 

I need help :

I have import an extraction from SAP to use on Qlik.

But, colonne suppose to have amounts is on format :

POSITIVE AMOUNTS :  1.500,00

NEGATIVE AMOUNTS : 1.500,00-

I can not  use NEGATIVE AMOUNTS with sign (-) at the end.

I need to change at correct format. 

Some one can assist ?

[cmutombo]

Hi Frank_Hartmann

Here below the CORRECT ONE. THANKS A LOT FROM YOU !

Load *, if(right([Amount],1)='-',
'-'&purgechar([Amount],'-'),
[Amount]),

Replace(if(right([Amount],1)='-',
'-'&purgechar([Amount],'-'),
[Amount]),'.',''),

Replace(Replace(if(right([Amount],1)='-',
'-'&purgechar([Amount],'-'),
[Amount]),'.',''),',','.') as Amount_

[cmutombo]

CORRECT ANSWER !

[cmutombo]

Hi Frank, 

Could you help with this formula... Something is wrong.

The result don't consider that i am suming All transaction of current month

=sum({$<[MonthName(Date)]= {"$(=MonthName(Today()))"}>}Amount_)