error in sum

[alec1982]

Hi,

I have a text box to sum a field based on filters of other fields as follow

=Sum(

    if ((([Year] = 2012)

           and (PLS = 1)

            )

        , [Amount  (USD-annual)]

        )

    )

It is giving me value = -

I know that if i comment PLS=1 I get the Nrs, so the error is in this field.

the field has values as follow

PLS

1

0

-

Anybody can help Please..

Thanks,

Alec

[swuehl · Accepted solution]

Are you sure that you have any values in field Amount for the combination of Year = 2012 and PLS =1?

Create three list boxes for Amount, Year and PLS, then select 2012 in Year.

Check if PLS = 1 is a possible value.

If yes, select 1 in field list box PLS and check if you've got any values in field Amount.

[alec1982]

Thanks for the replay,

yes. I do have values.

I created a table box and I see the values.

Thxs,

[alec1982]

I guess that I have figured this one out.

Thxs,