[Load Script] If Field A is 0 then Field B is 0

[DestinedTale]

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 

[MindaugasBacius]

If([amount due] < 0, 0, If(A < 0, A, ':')) as B

This should do the job.

[prieper]

if([A] < 0, [A], second condition) as [B]
should do

[nilaksh92]

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?