Use text parameter in a calculated field

[ryley.g.h]

I am setting up a material takeoff schedule for floors, but we have some floors that we must specify in linear ft instead of square feet. I need to calculate only the "tape" floor type as linear feet, while leaving everything else blank, or zero. I tried an if statement for this, but I can't seem to get the calculation to work. How can I achieve what I am trying to get?

[RDAOU · Accepted solution]

@ryley.g.h 

You cannot use Text as an IF condition. 

You need to use another type of parameter...example: Integer. to represent each type of material.

IE:

• Instead of IF(Text Parameter ="Text", Value1, Value2)
• Your calculated value would be IF(Integer Parameter = 1, Value1, Value2)

[ryley.g.h]

Worked like a charm.