When using expression calculation error

27327155

Summary

When using expression calculation error

Content

When using expression calculation error，

filter(measure using filter_expr)

but  filter_expr   = 0.00  The expression is invalid

[Deleted User]

I can't read anything on your screenshot so I'll need to ask some follow-up questions:

a) Is what you are filtering really a measure?

b) What are you trying to filter the measure BY?

Gianni Ceresa

If you filter the analysis directly with your condition " filter_expr   = 0.00 " does it work? Define the filter there to get the right filter and then move it back inside the FILTER.

Why are you writing 0.00 ? 0.00 == 0, it's just zero. Isn't you column maybe a varchar and so you need '0.00' ? That's why I suggest to define the filter as an analysis filter first to find out the exact syntax OBIEE accepts/wants for your condition.