Hi there

I'm having problems trying to do the following:

I have 4 fields, each with a 0 or 1, I want to be able to add these
fields together and base the output on if the total is = 3.

First I started with adding them together:

{ «MG_Q1»+«MG_Q2»+«MG_Q3»+«MG_Q4» }

output: 0+1+1+1

I them made this in to a SUM:

{ =«MG_Q1»+«MG_Q2»+«MG_Q3»+«MG_Q4» }

output: 3

So far so good This gives me the sum of the four fields fine.

Now I need to have an output of YES or NO, depending on if the total
=3, so I put this (based on examples I've seen online):

{ IF{ =«MG_Q1»+«MG_Q2»+«MG_Q3»+«MG_Q4» } } =3 "YES" "NO" }

Using this, I don't get any output at all

I've checked the data source and the fields are non-formatted etc, and
obviously add up OK (as with the second step) but seems I have the IF
clause incorrect.

Any help would be very greatly appreciated.... I'm starting to get
bumps on my head from banging it on the desk!

Many thanks

Stoo