MikeM670
asked on
The remaining text does not appear to be part of the formula error
Crystal Reports 2016
I have a formula where I want to sum a field based on a Datetime field called E911Data.EntryDateTime using a parameter value -1 to get the records from the previous year then that of the year contained in the parameter.
I get a The remaining text does not appear to be part of the formula error after sum({E911Data.Agency}). What is causing this error?
sum({E911Data.Agency}) where Year({E911Data.EntryDateTi me}) = {?Pm-?Year} -1
I have a formula where I want to sum a field based on a Datetime field called E911Data.EntryDateTime using a parameter value -1 to get the records from the previous year then that of the year contained in the parameter.
I get a The remaining text does not appear to be part of the formula error after sum({E911Data.Agency}). What is causing this error?
sum({E911Data.Agency}) where Year({E911Data.EntryDateTi
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER