Jump to content

How to calculate a field value


This topic is 8560 days old. Please don't post here. Open a new topic instead.

Recommended Posts

I am trying to create a formula to calculate square footage.

I have a field to enter the area and a field to identify the local measure via radio button selections: "sq feet", "sq meters", "sq tsubo".

If sq feet is selected = 1 x area; if sq meters = 3.3 x area; if tsubo selected = 35.5 x area.

Thanks

Link to comment
Share on other sites

You haven't specified what the name of the field is that selects the units... I'll call it units. I'll also assume the area is in a field called area...

Case(units="sq meters", area*3.3,

units="sq tsubo", area*35.5,

area)

This basically says: if the units field has the contents "sq meters" then multiply the area by 3.3, otherwise if the units field has the contents "sq tsubo" then multiply the area by 35.5, otherwise it equal to the area.

Note that the spelling of the units in the field is *very* inportant because the actual text string is used to determine the result.

Link to comment
Share on other sites

  • 3 weeks later...

Just a note:

You need to change the conversions in the above calculation to account for square units.

If a meter is 3.3 feet, then the conversion either needs to be done to each measurement ((3.3*length)*(3.3*width)) or substitute the value 10.89 (3.3 squared) into the calculation.

Of course, the second option will only work for rectangular area.

Link to comment
Share on other sites

This topic is 8560 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.