Getting Invalid Field Name error on calculated field

[jbhovden]

I have entered this expression in the expression box: IF([Revenue ($M)]>1000,">$1B")

and I'm getting the error "Invalid Field Name: $1B"

It seems like the calculated field can only accept number values for some reason, since this formula doesn't give an error: IF([Revenue ($M)]>1000,1)

How do I fix this?

Here's a screenshot of the error:

[Arthur_Fong]

Try this:

 IF([Revenue ($M)]>1000,[>$1B])