Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Can anybody point out what is wrong in my code?
if(Sounding Correction Status='Correction Done',
if(abs[Deviation after sounding]=abs[Difference Vs Log Survey],
green(), //When value of the both fields match they display green
if([Deviation after sounding] - [Difference Vs Log Survey]<>0,
yellow(), //When value of the both fields differ they display yellow
blue()
),
red() ////When Sounding Correction Status='Correction Not Done' they display red
if([Sounding Correction Status]='Correction Done',
if([Deviation after sounding]= [Summary.Difference Log vs Survey],
green(), //When value of the both fields match they display green
if([Deviation after sounding] - [Summary.Difference Log vs Survey]<>0,
yellow(), //When value of the both fields differ they display yellow
blue()
)),
red()
)
Hi,
You need to close the first if statement
if(Sounding Correction Status='Correction Done',
if(abs[Deviation after sounding]=abs[Difference Vs Log Survey],
green(), //When value of the both fields match they display green
if([Deviation after sounding] - [Difference Vs Log Survey]<>0,
yellow(), //When value of the both fields differ they display yellow
blue()
),
red() ////When Sounding Correction Status='Correction Not Done' they display red
)
Hi,
Maybe you have to close in braquets the field Sounding Correction Status. Like [Sounding Correction Status].
Saludos.
Hi,
the field 'Sounding Correction Status' don't exist AND you can't create fields that contain spaces, without using" " or [ ]
like this:
[Sounding Correction Status]
or
"Sounding Correction Status"
Perhaps try the below, closing the statement and correcting where bold
if([Sounding Correction Status]='Correction Done',
if(abs[Deviation after sounding]=abs[Difference Vs Log Survey],
green(), //When value of the both fields match they display green
if([Deviation after sounding] - [Difference Vs Log Survey]<>0,
yellow(), //When value of the both fields differ they display yellow
blue()
),
red()
)
)
if([Sounding Correction Status]='Correction Done',
if(abs[Deviation after sounding]=abs([Difference Vs Log Survey]),
green(), //When value of the both fields match they display green
if(([Deviation after sounding] - [Difference Vs Log Survey])<>0,
yellow(), //When value of the both fields differ they display yellow
blue()
),
red()
Still having error:
if([Sounding Correction Status]='Correction Done',
if([Deviation after sounding]= [Summary.Difference Log vs Survey],
green(), //When value of the both fields match they display green
if([Deviation after sounding] - [Summary.Difference Log vs Survey]<>0,
yellow(), //When value of the both fields differ they display yellow
blue()
),
red()
)
You have three ifs but only two closing parentheses.
don't know still showing some error ..bracket problems I guess
if([Sounding Correction Status]='Correction Done',
if([Deviation after sounding]= [Summary.Difference Log vs Survey],
green(), //When value of the both fields match they display green
if([Deviation after sounding] - [Summary.Difference Log vs Survey]<>0,
yellow(), //When value of the both fields differ they display yellow
blue()
)),
red()
)