count conditional to sum results

[#1]

Hi,

Im trying to count customers based on a series of sum = to or -= results. I'm using the set expression below but it returns 'error in set modifier'. Any suggestions on what Im doing wrong, or a better way to achieve this.

Thanks in advance

Grant

=If( vFundTypePlayable = '1',
(COUNT(
{$<
[SUMMARY_DATE] = { ">=$(vStartDate)<=$(vEndDate)"}
, sum({$<PNL_REAL={'0'}>})
, sum({$<PNL_RELEASED_BONUS={'0'}>})
, sum({$<PNL_PLAYABLE_BONUS-={'0'}>})
>}
DISTINCT [PARTY_ID])
)
)

[#2]

because its grouped by party id it becomes unique so Distinct isn't required, I was able to confirm this in the sub query results.

Your suggestion above returns a "error in set modifier ad hoc element list. ',' or ')' expected", with the following underlined.

"}>}PNL_REAL)=0"}>

[ramoncova06]

I don't see where the error could be since all of the brackets are closed properly