SQL query to return the value only if another dependant is not 0
I want to sum up a value only if another dependent is not 0 and then roll up the value after that.
I want to sum up a value only if another dependent is not 0 and then roll up the value after that.