Help with IF statement?

[Anonymous]

Hello,

I know this is a basic question but I need a little help. Can you please tell me what is wrong with my IF statement.

if([Rule Desc]='2x per node',$(vNodePercent2),

if([Rule Desc]='1 per 3 DRC',$(v1p3DRC-2),

if([Rule Desc]='10-20% per node',$(v1p3DRC-2),

if([Rule Desc]='Additional license per node',$(vAdd2)))))

Thank you,

[Clever_Anjos]

What kind of error are you receiving?

[Anonymous]

Error: Error in Expression ')' Expected

Thank you

[swuehl]

Have you checked that all variables expand to valid syntax?

And there is no typo in variables name?

[Clever_Anjos]

Weird, seems to be OK here, would you mind posting your screenshot?

[Anonymous]

I am not skilled at writing If statements. So I am sure its a closing bracket or something.

I was testing this in a text box. Because I want the value of the variable to show when a rules desc is showing.

[Anonymous]

What is -2 in $(v1p3DRC-2) and $(v1p3DRC-2)   ?

Are you trying to subtract 2 from the expression?

Then try below expression

=if([Rule Desc]='2x per node',$(vNodePercent2),

if([Rule Desc]='1 per 3 DRC',$(v1p3DRC)-2,

if([Rule Desc]='10-20% per node',$(v1p3DRC)-2,

if([Rule Desc]='Additional license per node', $(vAdd2))

)

)

)

[Clever_Anjos]

Please take a screenshot of your Properties / Edit Expression

[vardhancse]

What is the value for $(v1p3DRC-2)..?

[Anonymous]

I found the problem. There was no data for one of the variables. I was calcuation license count inside the variable. The part number I was working with didnt have a license count.

This is working fine.

if([Rule Desc]='2x per node',$(v2x),

if([Rule Desc]='10-20% per node',$(vNodePercent2),

if([Rule Desc]='1 per 3 DRC',$(v1p3DRC-2),

if([Rule Desc]='Additional license per node',$(vAdd2)))))

How do I add another field value. I want each row to have another field selection. I also need it to be And. What is the correct syntax.

Thank you for all the help. The comments above helped me troubleshoot the problem.

:O)