This content has been marked as final. Show 3 replies
I am trying to create a field/dimension based on multiple if statement.
However, I get error if I try to use multiple conditions under one if statement.
if([Country] = 'France ',[Valid_YN]= 'Yes',[Code]= 'AA5','AA6','AA3',[Branch]<>'221,'223','224',[Amount1],'0',
if([Country] = ''France' and [Process] = 'A','B' ,[Company] = 'X',[Amount1]+[Amount2])) as [Net_Amount]
Could any one please help me to work on the right approach towards this issue ?