Summary with a Value list.

[Lucky]

Hi

I have created a field and called it Delivery. It has 3 options in a value list ( SameDay, 24Hr & 48Hr ).

Is there a way of creating a Summary to show How many jobs were delivered on the Same Day or 24Hr or 48Hr. [color:"black"]

[falkaholic]

If I understand what you mean.

Make a self-relation (relation to the same file) to the 'Delivery' field.

Next make a new calculation field that does this

Count( SelfRelation::ID )

That will show the number of records that have the same delivery as the current record.

If you want the have a totals for each.

Do the same as the above but make 3 fields that just hold "Same Day" "24Hr" and "48Hr".

Then make 3 new relations from each of the 3 news fields to the delivery field and make 3 new calculation fields the do the count on each one of the new relations.

(how this makes some sense)