08-27-2015 10:24 AM
I created a table named rentals. This is what it pulls back.
I need to come up with the result being
Which is a formula of (sum All weightX wher scoreX not = to 0) / (sum All weightx where score = to 1)
How can I do this?
08-27-2015 10:48 AM
It's 68/20=3.4 given your data.
Here's a SQL solution...
create table want as
select sum((scorex=0)*weightx)/sum((scorex=1)*weightx) as score