Binary Logical operation is not permitted on INTEGER, LONG VARCHAR operand(s)

Question

Hi All,

I have two fact columns,When i try to calculate percentage=(f1/f2)*100 I get the below error.

I checked the Data type all seems okay.The report throws error as soon as the I add the calculated column.The report shows data with the two fact col without percentage calculation.

Regards

Gianni Ceresa · Answer

You aren't helping in helping you

Give up pseudo code, post the exact full formulas involved in your calculation (f1 and f2 and every other column referenced by those), post all the datatypes as defined by the admintool for all the presentation columns involved in these formulas.

(Column names are not confidential, we couldn't care less about the names you used and I doubt they contain private information in presentation tables or presentation columns names)

User_5282F · Answer

Hi Christian,

Is a OBIEE Analysis not a BI Publisher Report.

Regards

[Deleted User] · Answer

3627282 wrote:It's an OBIEE Report/Analysis ,Version 11.1.1.7.

It's either the one or the other. It's two different technologies, two different products, two different objects. So which one is it?