I'm getting the error message "This field cannot be summarized" for a field called {@VOIDEDPROC} in a formula called "Maximum" . The following are my formulas:
VoidedProc
if isnull ({PatientVisitProcs.Voided}) then 1
else
IF {PatientVisitProcs.Voided} = 1 then
(if cdate ({PatientVisitProcs.DateOfEntry}) > {%MinEDIDate} then
if cdate({PatientVisitProcs.DateOfEntry}) <= ({@2nd Filing}) then 0)
Else 1
Maximum
if maximum ({@VOIDEDPROC},{PatientVisit.PatientVisitId})= 0
then "Dirty"
else "Clean"
I used this same type of formula for evaluating some other data in my report with no issues. The formula that I used that works is below:
RCode
if trim({@ReasonCode1}) = "" then 0
else
if trim({@ReasonCode1})in [list of stringvariables]
then 0
else 1
RCodeStatus
if maximum ({@CleanDirty4},{PatientVisit.PatientVisitId})=0
then "Dirty"
else "Clean"
Thank you in advance
VoidedProc
if isnull ({PatientVisitProcs.Voided}) then 1
else
IF {PatientVisitProcs.Voided} = 1 then
(if cdate ({PatientVisitProcs.DateOfEntry}) > {%MinEDIDate} then
if cdate({PatientVisitProcs.DateOfEntry}) <= ({@2nd Filing}) then 0)
Else 1
Maximum
if maximum ({@VOIDEDPROC},{PatientVisit.PatientVisitId})= 0
then "Dirty"
else "Clean"
I used this same type of formula for evaluating some other data in my report with no issues. The formula that I used that works is below:
RCode
if trim({@ReasonCode1}) = "" then 0
else
if trim({@ReasonCode1})in [list of stringvariables]
then 0
else 1
RCodeStatus
if maximum ({@CleanDirty4},{PatientVisit.PatientVisitId})=0
then "Dirty"
else "Clean"
Thank you in advance