Format Issues with Numbers

[#1]

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”

[anbu1984 · Accepted solution]

Replace(Replace(InvoiceAmt,'-',''),',','.')

[#3]

Amazing...Thanks a lot Anbun

[suresh_rawat]

Hi,

Use this Expression.

='-' & Replace(Value,'.',',')

It will work for you.

Regards

Suresh

[anbu1984]

Please close the post, if your queries are answered

[#6]

use

=replace(num('411.35','#,##0.00')*-1,'.',','):

or use just replace and then set  the number format from the Number Tab in charts.

[its_anandrjs]

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

[#8]

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

[anbu1984]

Load If(InvoiceAmt Like '-*',Replace(Replace(InvoiceAmt,'-',''),',','.'),'-' & Replace(InvoiceAmt,',','.')) Inline [

InvoiceAmt

"-411,35"

"411,35" ];