We got daily, weekly and monthly buckets in our SNP Planning Book. We use Days supply standard macro, its calculating correctly for weekly and monthly but not daily. The values are little bit off.
If u select the data for multiple locations and drill down by location, by location the days of supply values are OK. But if u checks the total of days of supply, it doesnt make sense. The total values are neither average nor sum. How to read this total No.
Any advise is greately appreciated.
thx
Jeff