Don't laugh, Easy one, Avg a case statement 1

[Tapew0rm]

Hi,

Ok this should be easy but I obviously woke up on the stupid side of the bed. Here is what i'm tring to do basicly...

AVG (( Case

When X = Y

Then 1

Else 2) - (1))

End as Field_Name,


I keep getting incorrect syntax near ')'

 

[AlexCuse]

avg( Case        
     When X = Y
           Then 1
     Else 2 - 1 End) as Field_Name

Your ENTIRE case statement needed to be within the paren's.

Hope this helps,

Alex

[small]----signature below----[/small]
I don't do any programming whatsoever

Ignorance of certain subjects is a great part of wisdom

 

[Tapew0rm]

Thanks!