Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I would like another field value to change to 0 based on the first field. Something like this
If amount due is less than 0 then field B will be 0 then with another if condition
if([A] < 0, [A]) as [B], second condition
If([amount due] < 0, 0, If(A < 0, A, ':')) as B
This should do the job.
I think the below syntax might work
load
A,
if(A<0,0,if(A>0,Value/Field,DefaultValue)) as B
From xyz
Do let me know if this answers your query?