If/And Statement (9.0/2001)

[garcich1]

I'm trying to create a formula that says if [% Compl]>0 and [original]=1, then return a 1, else 0: this is the formula I used:
ACT_STARTS: IIf(([% COMP]>0 & [ORIGINAL]=1),1,0) but it's returning everything as a 0, can anyone help?

[Francois]

try :
ACT_STARTS: IIf(([% COMP]>0 And [ORIGINAL]=1),1,0)

[HansV]

The & operator is meant to concatenate strings:

strFirst = "Woody"
strLast = "Leonhard"
strTotal = strFirst & " " & strLast

This results in "Woody Leonhard".

You need the And operator:

IIf([% COMP]>0 And [ORIGINAL]=1,1,0)

Note: although it is allowed, I would never include a % in a field name (and I avoid spaces too.) Sometimes, using special characters can lead to unexpected results.

[garcich1]

Yes! it worked, thank you