# 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

##### Share on other sites

I have figured this out using the case function.

##### 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.

##### 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.

##### Share on other sites

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

## Create an account

Register a new account

• ### Similar Content

• #### Filemaker 6 for Mac issue.

By Tumma K,

• (and 4 more)

Tagged with:

• 8 replies
• 4,479 views
• #### FM3 upgrade to FM Pro 5.5 - Windows 8 installation possible?

By MrEddByrnes,

• (and 4 more)

Tagged with:

• 5,265 views
• #### Moving data from fp5 to fp13

By bmill,

• (and 4 more)

Tagged with:

• 2 replies
• 3,497 views
• #### Filemaker 5.5 database will not delete records on-line

By randyinla,

• (and 4 more)

Tagged with:

• 3,113 views
• #### Are there still hosting providers for filemaker 5.5?

By randyinla,

• (and 4 more)

Tagged with:

• 2 replies
• 2,739 views
×
×
• Create New...