Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAProbably a bit convoluted but it works!
Thanks for the Challenge.
Am looking at the final solution provided by you, and in the final output of the solution I am seeing multiple rows where Total - Point of Sale is Zero even when Inside - Point of Sale is != 0.
Ex - for Week of 2016-04-24, Inside - POS is 236 whereas Total - POS is Zero.
Shouldn't, Total (POS) = Inside (POS) + Outside (POS)?
Thanks,
Mohnish