expression condition

[#1]

Hi Experts,

I have attached a sample  qvw & an excel sheet associated to it.

In the qvw, there are three tables and one of them is the required output which i m struggling to get.

Please help me with the expression to get the required values

[sunny_talwar · Accepted solution]

Try this:

Sum(SA*SRDAYS)

or

Sum(Aggr(Sum(SA) *Sum(SRDAYS), RSMNAME, BRCODE))

[stabben23]

or: sum(aggr(sum(SA*SRDAYS),BRCODE))

[#4]

thank u so much sunny