Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 (([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))))
/
(
(
[Adjustment Type CDE]
='S'or
[Adjustment Type CDE]
[Adjustment Type CDE]
='RTN' or[Adjustment Type CDE]
='PLNC',
)))
Can attach your qvw with the question area/object highlighted? Thanks.
I am sorry i didnt get that, I am really new to this system what do you want me to do?
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.