Decode function error

[naga5566]

Hi all
I am using this and i am getting error ora:00937 not a single group group function.Any idea y this is so

DECODE(Tab1.BOOK_VALUE,0,1,sum((Tab2.Coll/Tab1.Col1)*100))

Thanks
Naga

 

[nimmy99]

Is this the correct syntax?

 

[naga5566]

It is this
DECODE(Tab1.Col1,0,1,sum((Tab2.Coll/Tab1.Col1)*100))

 

[nimmy99]

What are you going to do?
Which on this the search value and which one is the result ?

 

[naga5566]

Nimmy,
Its like this .I am implementing this in a measure object in designer.

If table1.col1 is 0 then it should be assumed as 1 using decode.Else i need to perform the calculation
Sum(Tabl1e2.Coll/Tabl11.Col1)*100


I think this is bit clear now.

 

[Sridharan]

If you look at the SQL generated it will be not be grouping by Tab1.Col1... So put the Sum outside the Decode and it should work....

Sri