What is in the calc [Benchmark / Portfolio] ?
BTW, if you have a Boolean, you can just say
IF [Boolean field] then (do whatever you do for "true" here) END
You don't have to say = TRUE
You can also do:
IF NOT [Boolean Field] then (do "false logic here) END
1 of 1 people found this helpful
Hi Joe, your solution of avoiding a "=" worked. thanks alot
Is that calc a table calc? That's what the error message was complaining about. That's why I asked what was in it.
hi joe, the error went away but the difference always equals 0. the original calc is not a table calc, just a calculated field.
Do you need help figuring that out? If so, I'll need a sample workbook.