How to calculate a field value

[ematson]

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

[ematson]

I have figured this out using the case function.

[Vaughan]

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.

[aricm]

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.