tally of conditions on a column

[Former Member]

i have a col that could be one of 3 values for part type. each detail row of an order has apart# which may have one of these 3 values

so I want to tally for example

part type A            Part type B             part type c

2                           3                             1

this means that 2 rows had parts belonging to type A etc.

for each order then reset for next order.

How do code for this in formula?

[ido_millet]

Simplest solution is to insert a CrossTab. Set Part Type as the column and Count as the summary type.

A slightly more complex solution is to create 3 formulas. 
The formula to count how many records had Part Type A Type A would look like this:

IF {OrderDetail.PartType} = "A" Then 1 ELSE 0

Then, SUM that formula to derive the conditional count.