Weighted average between dates

[haribabugv]

Hello Team,

• I am trying to find the weighted average between two dates for Class A inside a text box. Can you please let me know how to modify this below expression.

if(date(Date) >= '$(vStart)' and date(Date) <= '$(vEnd)',Sum(Aggr(Sum(Actual * Quantity)/Sum(Actual))))

• In another text box, i am trying to use  max weighted average (Class A,Class B) between vStart and vEnd.

Sample Data:

Message was edited by: Hari Babu Added Sample data set and sample file

[tresesco]

Try to share a sample qvw with inline/excel data and explain the expected output. That way you help us help you better.

[haribabugv]

I have just added it

[tresesco · Accepted solution]

Like this? PFA