Jump to content
We've recently updated our Privacy Statement, available here. ×

Calculated column with OVER function


Richard Pobi

Recommended Posts

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...