Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Avg([PaidperCust] / UniqueCount([DOS])) OVER ([Cust_ID])
- Cust_ID DOS Paid PaidperCust PaidPerDayPerCust
- 123 6/5/2018 $10 $50 16.66666667
- 123 6/6/2018 $10 $50 16.66666667
- 123 6/7/2018 $30 $50 16.66666667
- 45 7/1/2018 $45 $95 47.5
- 45 7/5/2018 $50 $95 47.5
Add Comment
Please, Sign In to add comment