Calculate Inventory Days

[vikas_nandanwar]

Hi,

I have Inventory Data Sheet with following Columns -

Date

Metal

Inv

Dept

Co.

I have Sales Data sheet with following Columns -

Date

Metal

Sales

Co.

My Date, Metal and Co is linked

Now I want to calculate Dept wise Inventory Days 

(Avg Dept Wise inventory )/(Avg Sales)

Please help how to calculate

Thanks

Vikas

[prma7799]

Like this??

Aggr(Count( Inventory Days ),Dept )

[vikas_nandanwar]

Nope

It should be like

(Avg dept wise inventory)  / (Dept Wise Sales)

I have Average Dept Wise inventory

But how to get dept wise sales

[prma7799]

Try like this

Aggr(Avg( Inventory Days ),Dept ) / Aggr(sum( Sale ),Dept )