Set Analysis

[#1]

I have this expression which works fine for this years data. But I am trying to get the same calculation for last year can someone help me with it... Thanks in Advance

(

Sum(if ([Adjustment Type]='Other Adjustments',[Adjustment Amount],0

))

+

(

Sum(if ([Adjustment Type CDE]='PLNC'and [Vendor ID]<>800790009,[Adjustment Amount],0

))

+

Sum

(if (([Flg - PLNC Account]=1 and [Adjustment Type CDE]='S') and ([Vendor ID]<>800790009 ), [Adjustment Amount],0

))

+

Sum

(if (([Flg - PLNC Account]=1 and [Adjustment Type CDE]='PLNC') and ([Vendor ID]<>800790009 ), [Adjustment Amount],0

))))

/

(

Sum(if

(

[Adjustment Type CDE]

='S'

or

[Adjustment Type CDE]

='PV' or

[Adjustment Type CDE]

='RTN' or

[Adjustment Type CDE]

='PLNC'

,

[Adjustment Amount],0

)))

[#2]

Can attach your qvw with the question area/object highlighted? Thanks.

[#3]

I am sorry i didnt get that, I am really new to this system what do you want me to do?

[#4]

Please attach the QVW report file you are working on, that you need help with. It is called something like ******.qvw. You can attach it to a post by going to the Options section, on the top.