Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
What is going wrong in the following script?
Only when Spend_time is according to the conditions A = NO, B = hour and C=Prestatie I want de value of Spend_time to be saved als Spend_Hours, else, return value zero.
IF (A ='NO',
IF (B ='hour', IF(C ='Prestatie', Spend_time,
0),0),0) AS Spend_hours,
Hi
If I understood you correctly:
If(A = 'No' And B = 'hour' And C = 'Prestatie', Spend_time, 0) As Spend_hours,
HTH
Jonathan
Hi
If I understood you correctly:
If(A = 'No' And B = 'hour' And C = 'Prestatie', Spend_time, 0) As Spend_hours,
HTH
Jonathan
Hi,
Try to put all the conditions together as If( A='NO' and B='hour' and C='Prestatie', Spend_Time, 0) as Spend_Hours.
Hi,
try
if((A ='NO') AND (B ='hour') AND (C ='Prestatie'), Spend_time,'0') as Spend_hours