Advertisement
Guest User

Untitled

a guest
Oct 27th, 2016
54
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.20 KB | None | 0 0
  1. **asset_revenue**
  2. 15
  3. 15
  4. 213
  5. 0
  6. 32
  7. 89
  8. -47
  9.  
  10. SUM([asset_revenue]) / SUM(CASE WHEN asset_revenue <> 0 THEN 7 ELSE NULL END)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement