average inventory amount formula

[#1]

There are date,starting date, end date, month, week in my qlickview. I neet to average inventory amount formula. Can u help me this issue. Thanks for helps.

[kaushiknsolanki]

Hi,

I feel you need to ask your business user about the exact formula.

Regards,

Kaushik Solanki

[jmvilaplanap]

It depends about your business user, but normally if you need a diary average you must to sum all the values and divide by the num of days.

What exactly you have in the table? Could you give an example?

[MarcoWedel]

maybe like this?

Avg(InventoryAmount)

hope this helps

regards

Marco

[balabhaskarqlik]

For Average calculation it can be:

Average(Inventory Amount)

To consider average calculation along with some other fields like:

Sum(Inventory Amount) / count({<Customer>} total distinct Month) (//Customer field is assumed).

[Anonymous]

Hi,

In general the formula would be (Opening stock+Closing Stock)/2 will give you the average inventory.

Stock at start date , Stock at end date you can use.

Regards,

Sadasiva

[Anonymous]

Hi ,

Go through this link it may helps.

Inventory turnover - Wikipedia

Regards,

Sadasiva

[Anonymous]

Hi Baskar,

monthly average inventory?

can you help me on this.

For example:

For Example: Date Range: 1 Jan - 31st March 2017

Avg Inventory = (Average of (Opening Stock on Jan 1 , Closing Stock on Jan 31 , Closing Stock on Feb 28 , Closing Stock on Mar 31))

How can use this as expression?

Regards,

Sadasiva