Money format

[its_rajvir]

Dear Experts,

I have Amount column in sales table. It is showing the amount like this : $174,343,405.00  but it should show: $174,343.405 .I don't have any idea about formating. can anyone please tell me why it is like that and how to correct this.

Thanks

[QlikSenseEnthusiast]

Hi Rajvir,

Please refer below image if this helps.

For field New_Amount,  i have code this at backend 
LOAD
City,
Amount,
NUM(Amount,'$#,##0') as New_Amount

Please mark this  as solution if it helps