Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ?
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_
CORRECT ANSWER !
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_)