Total C 1

[Toshilap]

I have Text field that I need to count how many 'C's per group. Any formula i am using gives me TRUE or Total of 'C's, not per group. I am placing it in the group.
SELECT
Count ({ORDER_DETAIL.LINE_STATUS_CODE})

ORDER_DETAIL.LINE_STATUS_CODE is set to be equal 'C' in Select Expert.Where am I wrong? THANKS

 

[lbass]

Place the field in the detail section and then right click on it->insert summary->count. Then suppress the detail section.

-LB

 

[Toshilap]

Thanks, get a star!