Sum Records/ CheckBox/Relationship

[Therber]

I have been working for sometime on this problem and just can't quite seem to get it to work - I am attempting to sum a field in records which have a common ID field while omitting those with the same ID which have a checkbox checked. Should I be using one or two self relationships?

Thanks.

[John Caballero]

Create a calculation in the related file that looks like this:

Case(checkbox=whatever value you use,0,field you want to sum)

Then from your main file, create a calculation:

Sum(relationship::calculation)

[CyborgSam]

You could make a relationship based on a calculation like this:

If( BoxIsChecked,

ID,

""

)

You will only relate to records with the box checked and with the proper ID.

Sam