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

User_5282F

Hi All,

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

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

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

Hi, you are talking about a BI Publisher report? Or an Answers analysis? What exact version? As you checked them, what are the datatypes? How did you check them? How is the exact formula of your column?

You need to be more precise and post more details as otherwise there are 10'223 possible guesses.

User_5282F

Hi Gianni,

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

The Dollar amount is double other columns are Varchar(Rep,division).

First column is an direct fact column F1,second column is derived using a case statement (Case when Division is H and Sale Rep='200' then filter (F2 using dim = 'XXX')...till here the report works fine.

as soon as I add a calculated column to calculate the percentage=(f1/f2)*100,I get this error.

Regards

[Deleted User]

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?

User_5282F

Hi Christian,

Is a OBIEE Analysis not a BI Publisher Report.

Regards

Gianni Ceresa

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)