Formula to count # of samples based on their status?

[leedy33]

In my report I'm trying to create a formula. What i have is a total # of samples which i get (through a formula) based on their group. Well now that i have the total # of samples for each group i want to take those samples and for each group of them i want to be able to disregard any of those that meet the criteria based on a seperate column which is their status. There are 5 possiblities for each sample and i want to exclude those samples that are "cancelled and ready invoice" By doing this i will be given a number of samples that are based on the other 3 status criteria which i then can make a fraction of the new # of samples over the total # of samples. Any help with this would be much appreciated. Thanks

Mark

 

[Madawc]

Try running totals, which can calculate values like percentage and also use formulas to include or exclude records.

Madawc Williams (East Anglia, UK)

 

[leedy33]

Im not sure as to how to make a running total/formula so that i can find the total # of samples in a group and then at the same time exclude those that meet the critera of the status.

 

[lbass]

Can you just eliminate those records from your report? You could enter a record selection formula like:

not({table.status} in ["Cancelled","Ready Invoice"])

Otherwise you could create a formula like:

if not({table.status} in ["Cancelled","Ready Invoice"]) then 1 else 0

Place this in the detail section and insert a summary (SUM, not count) on it.

-LB