Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want the value of column 2 to be output like this: if column 1 is greater than 4320 then display the value in column 2 as 4320 and if column 1 is less than 30 then display the value 30 in column 2.
Now I can only if the value is less than 30 then it shows 30, but not greater than 4320 yet.
Try this :
if(sum(Column1)<30 , '30' , if(sum(Column1)>4320, '4320' , sum(Column1)))
Regards,
Aditya
Try this :
if(sum(Column1)<30 , '30' , if(sum(Column1)>4320, '4320' , sum(Column1)))
Regards,
Aditya