Hi,
I am using the formula
IF {FF_ASS_UNIT_RCVE_INT_WEEK_VIEW.ELIG_ADULT_CHILD} = "ELIGIBLE ADULT"
THEN
DISTINCTCOUNT({FF_ASS_UNIT_RCVE_INT_WEEK_VIEW.CLIENT_MEMB})
here crystal is not considering the condition
{FF_ASS_UNIT_RCVE_INT_WEEK_VIEW.ELIG_ADULT_CHILD = "ELIGIBLE ADULT"
and giving me the distinctcount for all the records.
How can i do a distinctcount with a condition in the formula
Any help is appreciated
Thanks.
I am using the formula
IF {FF_ASS_UNIT_RCVE_INT_WEEK_VIEW.ELIG_ADULT_CHILD} = "ELIGIBLE ADULT"
THEN
DISTINCTCOUNT({FF_ASS_UNIT_RCVE_INT_WEEK_VIEW.CLIENT_MEMB})
here crystal is not considering the condition
{FF_ASS_UNIT_RCVE_INT_WEEK_VIEW.ELIG_ADULT_CHILD = "ELIGIBLE ADULT"
and giving me the distinctcount for all the records.
How can i do a distinctcount with a condition in the formula
Any help is appreciated
Thanks.