Set analysis problem

[#1]

Dear All,

I am facing problem in seta analysis.

In variable vTest2 i am storring all the growth vendor name through concat.

vTest2=Concat(DISTINCT IF(AGGR(sum( {<@_Date={">=$(vFinStartDatePY)<=$(vMonthEndPY)"},@_FinFullYear=,@_FinQuarter=,@_Month=>} #_Sales_Qty)< sum( {<@_Date={">=$(vFinStartDateCY)<=$(vMonthEndCY)"},@_FinFullYear=,@_FinQuarter=,@_Month=>} #_Sales_Qty),CUSPARTYNAME),CUSPARTYNAME),',')

I have to write a expression for sum of the sale quantity for growth vendor.

Expression :-

=sum({$<@_Date={">=$(vFinStartDateCY)<=$(vMonthEndCY)"},@_FinFullYear=,@_FinQuarter=,@_Month=,CUSPARTYNAME={'$(vTest2)'}>} #_Sales_Qty)

-

sum({$<@_Date={">=$(vFinStartDatePY)<=$(vMonthEndPY)"},@_FinFullYear=,@_FinQuarter=,@_Month=,CUSPARTYNAME={'$(vTest2)'}>} #_Sales_Qty)

Means how much is the growth quantity from previous Year.

But its not working.

Please need your help.

Regards,

Sukamal

[#2]

Hi Tresco ,

I need another help.

I need not billed vendor count and previous yr qty for not billed vendor.

I modify the excel sheet.

Please check it.