Multiply then divide

[JaredPilbeam2]

Is it not possible to do this?

${carpetyards} * 84.4 div 2000

 I'm not getting an error but I'm also not getting a result.

[jcarlson · Accepted solution]

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.

jcarlson_0-1635354399961.png

jcarlson_1-1635354633687.png

[JaredPilbeam2]

Josh,

The carpetyards field is an integer type.

222.png

It wasn't (isn't) working in S123 Connect, but it is in the web app. Go figure. But, I guess I have a new problem. It isn't showing decimals?

JaredPilbeam2_0-1635357441411.png

I'm no good at math, but my calculator tells me 66 * 84.4 / 2000 = 2.78.

[jcarlson]

You have tons set to an integer as well. Set it to decimal to fix that.

[JaredPilbeam2]

That did it. Thanks a bunch.