Calculation of rotation days

[vikas_nandanwar]

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

[sunny_talwar]

Check here:

Calculation of Inventory Average

[vikas_nandanwar · Accepted solution]

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)))