In CR 8.5, I definded a formula field,
{@Credit Hours Hold} as follows:
"Sum ({SFRSTCR.SFRSTCR_CREDIT_HR_HOLD},{@CAPSName})"
where {CAPSName} is the formula field by which the only group is sorted.
After using {@Credit Hours Hold} in another formula field, {@Full-time Part-time Hrs}:
"If {SFVETR1.TOTAL_CREDIT_HOURS} = 0 and {SFVETR1.ESTS_CODE} IN "DI""FW"
Then {SFVETR1.TOTAL_BILLING_HOURS}
Else If {SFVETR1.TOTAL_CREDIT_HOURS} = 0 and {SFVETR1.ESTS_CODE} IN "BW"
Then {@Credit Hours Hold}
Else {SFVETR1.TOTAL_CREDIT_HOURS}"
I get this error message in a box:
"A Cross-Tab column has been specified on a non-recurring field." "OK"
NO, it's not OK. I guess the Sum is being evaluated in the "group pass" and prevents my using it in a formula field. How can I work around this?
{@Credit Hours Hold} as follows:
"Sum ({SFRSTCR.SFRSTCR_CREDIT_HR_HOLD},{@CAPSName})"
where {CAPSName} is the formula field by which the only group is sorted.
After using {@Credit Hours Hold} in another formula field, {@Full-time Part-time Hrs}:
"If {SFVETR1.TOTAL_CREDIT_HOURS} = 0 and {SFVETR1.ESTS_CODE} IN "DI""FW"
Then {SFVETR1.TOTAL_BILLING_HOURS}
Else If {SFVETR1.TOTAL_CREDIT_HOURS} = 0 and {SFVETR1.ESTS_CODE} IN "BW"
Then {@Credit Hours Hold}
Else {SFVETR1.TOTAL_CREDIT_HOURS}"
I get this error message in a box:
"A Cross-Tab column has been specified on a non-recurring field." "OK"
NO, it's not OK. I guess the Sum is being evaluated in the "group pass" and prevents my using it in a formula field. How can I work around this?