Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a set of data consisting of columns as Month, Week, Office, Sales and Inv.
Few points to be considered-
My period starts from 1st Jan 2017.
I need to calculate Rotation days as
(No of Days from 1st Jan) / [(Total Sales till Date)/(Average Inv till date)]
When i distribute it month wise, i don't get the average
Please help
I am attaching my app and data with this.
Thanks,
Vikas
Avg(Days)*
RangeAvg(Above(TOTAL(Avg(Aggr(Sum(Inv),Months,Week))),0,If(RowNo()<6,RowNo(),6)))/
RangeSum(Above(TOTAL(Sum(Sales)),0,If(RowNo()<12,RowNo(),12)))
Check here:
Avg(Days)*
RangeAvg(Above(TOTAL(Avg(Aggr(Sum(Inv),Months,Week))),0,If(RowNo()<6,RowNo(),6)))/
RangeSum(Above(TOTAL(Sum(Sales)),0,If(RowNo()<12,RowNo(),12)))