Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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:
Try this:
IF([Revenue ($M)]>1000,[>$1B])