topic Re: average inventory amount formula in QlikView

average inventory amount formula

Thu, 22 Jun 2017 09:10:42 GMT

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.

Re: average inventory amount formula

kaushiknsolanki — Fri, 30 Jun 2017 10:07:04 GMT

Hi,

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

Regards,

Kaushik Solanki

Re: average inventory amount formula

jmvilaplanap — Fri, 30 Jun 2017 13:08:30 GMT

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?

Re: average inventory amount formula

MarcoWedel — Fri, 30 Jun 2017 22:20:10 GMT

maybe like this?

Avg(InventoryAmount)

hope this helps

regards

Marco

Re: average inventory amount formula

BalaBhaskar_Qlik — Sat, 01 Jul 2017 07:14:06 GMT

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

Re: average inventory amount formula

Anonymous — Thu, 06 Jul 2017 10:52:10 GMT

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

Re: average inventory amount formula

Anonymous — Thu, 06 Jul 2017 10:58:10 GMT

Hi ,

Go through this link it may helps.

Inventory turnover - Wikipedia

Regards,

Sadasiva

Re: average inventory amount formula

Anonymous — Thu, 06 Jul 2017 11:11:19 GMT

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