Calculated Data item

[chinnucognos]

Hi everyone,

I have dimensional data in a report, i need to display ((Q1*Q2)+(S1*S2))/(Q2+S2) data item in list report.
Now when the Q1=Q2=S1=S2=0, then it has to display '0' as per calculation, but it is throwing as '/0'.

I have nvl function, but it is throwing error as "nvl fucntion not valid for integer, character and double data types"
Can you guys help on this......

[navissar]

You can actually skip all the logic, highlight the column, go to data format, set the format to number and under "Divide by zero characters" put in "0".

[chinnucognos]

Thanks a lot Avissar... it worked :D