Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi,
I feel you need to ask your business user about the exact formula.
Regards,
Kaushik Solanki
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?
maybe like this?
Avg(InventoryAmount)
hope this helps
regards
Marco
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).
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
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