Formula Creates Dups

[ggies07]

Hello,

I have this formula that I created:

If {StsAttrsSpecAttr_5.StsAttrsSpecAttr_5_Date} >= Date (2013,08 ,22 ) then "AO"

It works fine, but creates dups in the report for any student that has more than one "Applied Out" Attribute. I thought putting the date in formula would suppress those, but it is not working. It puts the "AO" next to the student that has it for this year and then creates a duplicate name if the child has it on their record from a previous year.

Any way to make the formula more detailed so that this doesn't happen?

Thanks!

 

[Charliy]

First, try putting an ELSE ' ' at the end of the formula.

Where are you executing the formula? If it's in a group footer, it is only evaluating once per group.

Without knowing what you data looks like, that's all I can think of.