Add $9.00 to an amount in field

[Susan]

I have a field with a total amount. I need to add $9.00 to that amount. Can anyone help me with a rule to do this.

[dreimer]

Try this:

 

var price = Field("Price") // Your field here
return '$' + (StringToNumber(price.replace(/[^\d\.]/g, '')) +9);

[Susan]

Thanks. This rules works great except I need 2 decimal places. ($525.00).

[Susan]

Thanks for the reply.

 

For some reason my result is $9 with this rule. The entry in my field is $515.00. The previous rule below resulted in $524. I need it to be $524.00.

 

var price = Field("External_Data::cTotal") // Your field here

return '$' + (StringToNumber(price.replace(/[^\d\.]/g, '')) +9);

[dreimer]

I had an error in the post I deleted. Try this.

 

var price = Field("YourFieldHere")
var price2 = (StringToNumber(price.replace(/[^\d\.]/g, '')) + 9);
return '$' + FormatNumber("#,###.00", price2)

Edited June 29, 2017 by dreimer

[Susan]

Thank you! You've saved me a lot of time and headaches!