September 16, 200223 yr 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"]
September 18, 200223 yr 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)
Create an account or sign in to comment