Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I got a very basic question but cannot make it work
Got two tables I want to joint
In both I have "Invoice Amount" but Table A : Comes from a systems and Values are like “-411,35” while fromm system B Values are like “411.35”
What is the script to make 411.35 be “-411,35”
Replace(Replace(InvoiceAmt,'-',''),',','.')
Replace(Replace(InvoiceAmt,'-',''),',','.')
Amazing...Thanks a lot Anbun
Hi,
Use this Expression.
='-' & Replace(Value,'.',',')
It will work for you.
Regards
Suresh
Please close the post, if your queries are answered
use
=replace(num('411.35','#,##0.00')*-1,'.',','):
or use just replace and then set the number format from the Number Tab in charts.
Try this way also
Load
FABS( InvoiceAmt ) AS InvoiceAmt
From Location;
Or
Load
IF ( InvoiceAmt < 0, Num( InvoiceAmt * -1,'#,##0.00') ), Num( InvoiceAmt,'#,##0.00') ) AS InvoiceAmt
From Location;
Regards
Anand
I checked once again and it works only for Debit values i.e: 411.35 be “-411,35” but not when I got Credit Values
-411.35 be “411,35” so I need some kind of If Function as well
Load If(InvoiceAmt Like '-*',Replace(Replace(InvoiceAmt,'-',''),',','.'),'-' & Replace(InvoiceAmt,',','.')) Inline [
InvoiceAmt
"-411,35"
"411,35" ];