
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
average inventory amount formula
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.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
I feel you need to ask your business user about the exact formula.
Regards,
Kaushik Solanki


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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?


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
maybe like this?
Avg(InventoryAmount)
hope this helps
regards
Marco

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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).

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Baskar,
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
