Error: Garbage after expression: ')'

[#1]

Hi

I am adding a trigger to a field in document properties using the following if statement

=If(GetFieldSelections([Analytical Type])='Timeliness',1,
If(GetFieldSelections([Analytical Type])='Accuracy',2,
If(GetFieldSelections([Analytical Type])='Completeness',3,
If(GetFieldSelections([Analytical Type])='Validity',4,
0))))

However I keep getting the error above.

Any ideas what wrong?

[sunny_talwar]

Don't see anything wrong, but you can try with this

=Match(GetFieldSelections([Analytical Type]), 'Timeliness', 'Accuracy', 'Completeness', 'Validity')

[vishsaggi]

Are there any hidden brackets before adding your IF script just click Ctrl+A and delete. Then add the IF statements. Just in case..

[ziadm]

remove the = sign infront of the expression  

If(GetFieldSelections([Analytical Type])='Timeliness',1,
If(GetFieldSelections([Analytical Type])='Accuracy',2,
If(GetFieldSelections([Analytical Type])='Completeness',3,
If(GetFieldSelections([Analytical Type])='Validity',4,
0))))

[vishsaggi]

Hello Ziad,

i wonder why = sign would effect here?

[andrei_delta]

Hello,

I came across this problem recently...you can put the GetFieldSelections([Analytical Type] in a variable and then use your expression like this:

If($(YourVar)='Timeliness',1,

     If($(YourVar)='Accuracy',2,

          If($(YourVar)='Completeness',3,

               If($(YourVar)='Validity',4,

                    0)

             )

     )

)

Hope it helps,

Andrei

[Peter_Cammaert]

Maybe replace the second equal sign by a comma?

[sunny_talwar]

Fixed