Syntax error in my code

[trishita]

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

[jmvilaplanap]

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

)

[fvelascog72]

Hi,

Maybe you have to close in braquets the field Sounding Correction Status. Like [Sounding Correction Status].

Saludos.

[YoussefBelloum]

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"

[Anonymous]

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()

        )

)

[sasiparupudi1]

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()

[trishita]

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()
)

[m_woolf]

You have three ifs but only two closing parentheses.

[trishita]

don't know still showing some error ..bracket problems I guess

[m_woolf · Accepted solution]

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()
)

• Re: Syntax error in my code