Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Like this??
Aggr(Count( Inventory Days ),Dept )
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
Try like this
Aggr(Avg( Inventory Days ),Dept ) / Aggr(sum( Sale ),Dept )