Conditional Sum

[APost]

Hey Thrill seekers!

I'd like to create a calculation, could be a summary field as well I suppose, that totals records that match a specific criteria. I've a summary value that of course totals the "Risk" field in a database, but I'd like it to only total the "Risk" value in records that also have an "Open" value in another field in the same table.

Any Ideas?

[bcooney]

Summary fields total the records found. So, by finding only Open, your summary field will show the total risk for those open found records.

You could create a calc field, OpenRisk = If ( status=Open; risk; "") and then use a summary field on OpenRisk.

You can avoid summary fields if you use a relationship from another table into the table that contains the risk values.

[APost]

I've got the first solution to work, but haven't seen how to do it without the summary field. I do have the two tables linked in a relationship, but haven't seen how to eliminate the Summary field.

[bcooney]

What two tables?

[Cabinetman]

I'm gonna try just adding my question since it's basically the same...

I need a field that I can put onto a form view record to sum up quantity on matching product records based upon UPC so I get a total quantity count.

Sometimes a product gets duplicated by mistake but mostly on purpose and I need to see how many total there are.....

Thanks !

Headed to the DR for a checkup and will check in later....