Calculated Fields Help

[Mossy]

I'm trying to create a caculated field for a course. The question is basically if column1 value is greater than a certain number then the calculated field should display a rate -500.



I've tried all the expression builders and looked at common operators and I can't figure out how to do this. Any help would be appreciated.

[June7]

The field is set as a Calculated datatype? Sounds like a simple calculation. Show the expression you tried. What happened - error message, nothing, wrong results?

[Mossy]

The field is set as a Calculated datatype? Sounds like a simple calculation. Show the expression you tried. What happened - error message, nothing, wrong results?

It may sound simple, but I can't figure it out. I've tried proposedrate: [column1]>6 = [column2]-500. I know this probably is really far off but unsure what to do. I don't necessarily want the answer, but maybe some guidance. Should I be using iif

[June7]

Use IIF:

IIF([column1]>6, [column2]-500, Null)

or

IIF([column1]>6, [column2]-500, 0)

or whatever you want in place of Null or 0

[Mossy]

Thank you very much