Not sure how the order of operations works in S123, but I can get a similar expression to work just fine.
How is your carpetyards field formatted? Is it possible the form is reading it as text? When I enter a string like "8,800", it fails to compute.
- Josh Carlson
Kendall County GIS