topic Re: How to calculate Stock with Weighted average ? in QlikView

How to calculate Stock with Weighted average ?

Fri, 13 Nov 2015 06:07:54 GMT

How to calculate stock with weighted average by using stock ledger?

marcus_sommer — Fri, 13 Nov 2015 09:39:12 GMT

I think this will be helpful: Average – Which average?

- Marcus

Anonymous — Fri, 13 Nov 2015 09:44:51 GMT

could you share some sample data?

else go thru:

miguelbraga — Fri, 13 Nov 2015 10:31:34 GMT

Hey there,

Do you have a qvw in which you need that average so that we can provide a solution for your problem?

Thanks,

Fri, 13 Nov 2015 10:55:29 GMT

In my stock i have same TWO quanties which i purchased at different rates follows:

srno Item qty product_rate value

1. A 10 1 10

2. A 6 1.5 9

Now in my stock have 5qty from my 1st purchase (with purchase rate as rs.1)

and 2nd purchase i have 6qty .

now as per me weighted avg: is =

total qty=5+6=11 and value=5+9=14

and product rate changes to rs.1.27

Anonymous — Fri, 13 Nov 2015 11:07:18 GMT

For weighted avg, you can try:

sum(Value)/sum(Qty)

miguelbraga — Fri, 13 Nov 2015 11:10:46 GMT

Or something like this:

= Sum(Value) / Count(Value)

marcus_sommer — Fri, 13 Nov 2015 11:14:50 GMT

Within charts you could use something like this:

rangeavg(above(sum(value), 0, rowno(total)))

and within the script you could use peek() and previous() to access previous records: Peek() or Previous() ?

- Marcus