Question Need Help Building a Expression

[diazr]

Can someone please help me construct the expression I have below. I'm getting an expression error. The expression should add a "1" to the count if it finds a "YES" in the field [form104Count] and a "0" if not.

104COUNT: Sum(([form104Count]="YES"),1,0)

Thank you!

 

[DanWall]

You are missing an "iif" function.... try:
104COUNT: iif([form104Count]="YES",sum([form104Count])+1,{whatever value you want on false})

Is this sort of what you're after?