G
Guest
I would like to change a number that is a Negitive number, say -100 and
change it to 100 and I want to change a positive number, say 100 to -100.
This needs to be formatted as currency.
I want to show a loss in product say -10 broken widgets * $10.00 to the
customer as a charge $100.00, not ($100.00) a credit; and I want returns say,
10 returned widgets 10 widgets * $10.00 to the customer as a Credit
($100.00), not a $100.00 charge.
The expressions I am using to calculate are as follows:
ShipRecReconcile: [SumOfCustomerReturned]-[SumOfCustomerRec] and
ReconcillationAdjustment: ([ShipRecReconcile]*[UnitPrice])
How can I change a negitive number to positive and vice versa?
change it to 100 and I want to change a positive number, say 100 to -100.
This needs to be formatted as currency.
I want to show a loss in product say -10 broken widgets * $10.00 to the
customer as a charge $100.00, not ($100.00) a credit; and I want returns say,
10 returned widgets 10 widgets * $10.00 to the customer as a Credit
($100.00), not a $100.00 charge.
The expressions I am using to calculate are as follows:
ShipRecReconcile: [SumOfCustomerReturned]-[SumOfCustomerRec] and
ReconcillationAdjustment: ([ShipRecReconcile]*[UnitPrice])
How can I change a negitive number to positive and vice versa?