I have a simple set of 4 cases I want to operate as a formula in a field:
case JoinTime > 13.15
PanelJoin = “Humor”
case JoinTime > 12.00
PanelJoin = “Historical”
case JoinTime > 10.45
PanelJoin = “Best”
case JoinTime > 9.15
PanelJoin = “Debut”
This works fine if I enter the PanelJoin field and execute. But as a recalculate field or morph to fill with formula or anything else I can think of globally, it fails. Errors like this: Expression contains an operand when an operator was expected
But then, I find that what I think of as a “formula” is working as “code” in the field properties. This is a recurring nightmare in my 30 (?) years of Panorama use, and I just can’t seem to get these ducks in a row. I’m pretty sure I solved/understood it about 6 months ago, but today not so. Blame in on Covid, maybe.
The manual bit on “case” calls it a formula; and I can get the same result with a series of if/elseif lines. Works on entering/leaving a cell edit, but no other way I’m trying to do it.
There was also an error message somewhere during the last hour or two telling me my field didn’t exist, but of course, it does.
I hope the answer is insanely simple. I’ve thought of just entering each cell in my result field but there are 856 records. Actually, if I’d done that instead of typing this I’d probably be done. But I wouldn’t know what I’m doing wrong. Plus, I have another field to apply “case” to…