Crystal XI - Summarizing Counts

I have attached a report where at the report footer there is formula, SE Detail, and within the formula is another formula for Segment Counts, with formulas within.  Most of the detail formulas I am able to get counts on, but the 2 with the // I keep receivng a message that I cannot summarize the formula.  Could anyone give me a clue on why these 2 formulas I cannot summarize the data looks similar to other formulas so I am a little preplexed.

Count({@INS_Member Detail}) +
Count({@REF_Subscriber Detail}) +
//Count({@REF_Member Policy Detail}) +
Count({@REF_Subscriber_All Detail_17}) +
//Count({@REF_Subscriber_All Detail_DX}) +
Count({@DTP_Member Detail}) +
Count({@DTP_Member_336 Detail}) +
Count({@DTP_Member_All_356 Detail}) +
Count({@NM1_Member Detail}) +
Count({@N3_Member Detail}) +
Count({@N4_Member Detail}) +
Count({@DMG_Member Detail}) +
Count({@HD_Member_All Detail}) +
Count({@DTP_Member_All_348 Detail}) +
Count({@DTP_Member_All_349 Detail}) +
Count({@LX1}) +
Count({@NM1_P3_Provider Detail})

Formulas in question:
REF_Member Policy Detail:

"REF" + "*" +
//"1L" + "*" +
//"W0002961" + "~"
{@REF_REF01_Member Policy_Reference Identification Qualifier} + "*" +
{@REF_REF02_Member Policy Reference Identification} + "~"
 
REF_SUBSCRIBER_All Detail DX:

"REF" + "*" +
"DX" + "*" +
"1000" + "~"
Summarizing-counts.rpt
GrapeladyAsked:
Who is Participating?
 
mlmccConnect With a Mentor Commented:
Didn't see the attached report.

I changed the formulas as follows
REF_SUBSCRIBER_All Detail DX:
If {EMCS_CURRENT_SAL_JOB.ACTION_DATE} > date(0,0,0) then
    "REF" + "*" +
    "DX" + "*" + 
    "1000" + "~"
ELse
    "REF" + "*" +
    "DX" + "*" + 
    "1000" + "~"

Open in new window


REF_REF01_Member Policy_Reference Identification Qualifier
If {EMCS_CURRENT_SAL_JOB.ACTION_DATE} > date(0,0,0) then
    "1L"
ELse
    "1L"

Open in new window

REF_REF02_Member Policy Reference Identification
If {EMCS_CURRENT_SAL_JOB.ACTION_DATE} > date(0,0,0) then
    "W0002961"
ELse
    "W0002961"

Open in new window


The three formulas always return the same values but to the system it looks like they depend on a database field and therefore are calculated in the pass where summaries can be done and not in the pass before summaries.

After doing it that way I also tried this and it also worked.
REF_REF01_Member Policy_Reference Identification Qualifier
{EMCS_CURRENT_SAL_JOB.ACTION_DATE};
    "1L"

Open in new window


mlmcc
Summarizing-counts.rpt
0
 
mlmccCommented:
REF_SUBSCRIBER_All Detail DX:
Doesn't have a database field in it so it is viewed as a constant and therefore doesn't have a "count".  Its count if you will would be the same as the count of all records.

REF_Member Policy Detail:

 What are these 2 formulas?
 {@REF_REF01_Member Policy_Reference Identification Qualifier}
 {@REF_REF02_Member Policy Reference Identification}

mlmcc
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.