Jump to content

Cross table using Case or If Statement


Richard Pobi

Recommended Posts

I have a Sales and a Revenue column.

When the Sales amount is lower than the Revenue then apply the following logic in a Cross Table.

Sales is 5.99 lower(Sum([Revenue]) then 3

End as [status]

id,Sales,Revenue,Status

1,100,95,3

2,90,100,1

3,80,100,1

4,105,110,3

5,60,63,3

6,20,30,1

7,30,37,2

8,20,26,2

9,50,52,3

Thanks

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...