Calculated column with OVER function

[Richard Pobi]

I am using the OVER function for a calculated column but I keep getting error.

case

when [Category]='Good' then Avg([Actauls])over ([id])

End

The above expression works fine. The below expression is what I want to apply, but it gives error . I need to add the value 10 after the average.

case

when [Category]='Good' then Avg([Actauls]) +10 over ([id])

End

Attached is my dxp file. Thanks

[Shashank Gurnalkar]

The 'over' keyword expects aggregated function before it which defines on which particular subset you want to apply the aggregation. Adding extra '+10' makes the expressioninvalid. May I know what exactly you want to do Or you can use the following expression if this helps.

case

when [Category]="Good" then Avg([Actauls]) over ([id]) + 10

End

[Richard Pobi]

This helps thanks very much.