Cross table using Case or If Statement

[Richard Pobi]

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

[Shashank Gurnalkar]

Use the following custom expression:

case

when Abs(Sum([sales]) - Sum([Revenue]))=6) and (Abs(Sum([sales]) - Sum([Revenue]))=8 then 1

End as [status]

[Richard Pobi]

It works thanks.