Adding days to calculate in SQL statement

[Jason Alshouse]

Current statement is looking at day 1 production vs. day 0. 1 - ((case when Sum(If([Production Day]=1,[Gas],null))>Sum(If([Production Day]=0,[Gas],Null)) then 1 else 0 end) / UniqueCount([jobId])) How can I write it to to look at day 1, day 2, and day 3 production vs. day 0

[Shuting Fu]

Try this -

1 - ((case when Sum(If([Production Day]=1 or [Production Day]=2 or [Production Day]=3,[Gas],null))>Sum(If([Production Day]=0,[Gas],Null)) then 1 else 0 end) / UniqueCount([jobId]))