Skip to Content
0
Aug 04, 2023 at 05:13 PM

Count Text Field "how many occurrences"

104 Views

Hi there, In crystal reports

I am trying to create a formula/ summary of how many times "Warranty" shows up in the Comments column, and a separate count of "Parts".

Ideally having 2 separate formulas to count each item would be great.

What i've tried so far was

formula name: Warranty

if {report.name.comments} = "Warranty" then 1 else 0

Then inserted a Summary with the warranty formula, I tried (Sum, Count, Count distinct) and it was all incorrect.

Help? thank you in advance.

Title: Comments:

image.png

image.png

Attachments

image.png (2.2 kB)
image.png (2.9 kB)