Set Analysis in nested what if expression

[#1]

I'm trying to translate this if, then, else construction to a set analysis expression..

SUM(if(Column1=[vValue] and Column2=1 AND Column3=0 and YEAR(Today)-2
, if(Colomn4='C' or Colomn4='VV' and YEAR(Today)-2, SALES*(-1)
, SALES)))/1000

This is what I have now but it's not working :(...

if(Column1=[vValue] AND Column2=1 AND Column3=0,sum({<YEAR(today)-2>}SALES*(-1)),
if(Column4='A' OR Column4='B',sum({<YEAR(today)-2>}SALES*(-1)),
SALES))/1000

can someone help me out :-))?

[#2]

Hi

Looks rather complex, can you "devide and conquer"

Use a straight table and do the evaluations one by one, then start to concat and post the one that does not work?

Good luck

Juerg

[#3]

I will try that approach 🙂 thanks!