Skip to Content
0
Former Member
Jun 06, 2011 at 03:36 PM

Error when using running total variable in formula

25 Views

This is probably an easy syntax problem, but I'm fairly new to Crystal reporting. I created a running total variable (count) called InquiryTypeSubtotal that simply counts the number of records. I have one grouping level, and in the group footer I'd like to print a line showing the total count for that group that looks like

Total inquiries for Assistive Technology: 3

To accomplish this I'm using a formula field with the following syntax:

"Total inquiries for " + {CnAttrCat_1.CnAttrCat_1_Description} + ": " + ToText(@InquiryTypeSubtotal)

When I try to check the formula, I get the error message "The ) is missing." What am I doing wrong?

Thanks,

Alec