Set Analysis with two sub-Set Analysis don't work

[lprill]

Hi,

i have the following Set-Analysis:

SUM( DISTINCT
	{<
		prospect={'B', 'C'},
		Rolling12turnover={">=$(=vTurnover12Mon)"},
		Rolling12purchasedates={">=$(=vPurchasedates12Mon)"},
		Clientnr={"=sum(
					{<
						inv_date={[>=$(=date('$(vFilterdate)'))]}
					>}
					purchasedate)>=$(=$(vpurchasedatesSFilter))"},
		Clientnr={"=sum(
				{<
					inv_datum={[>=$(=date('$(vFilterdate)'))]}
				>}
				turnover)>=$(=$(vturnoverSFilter))"}
	>}
flag_check)

Looking quite simple to me, but it don't work.

The first three statements always work and also together with one of the last two, but the last two statements in the Set-Analysis don't work together.

Any Suggestions or tips on this?

Thank you in advance.

[agigliotti · Accepted solution]

you can try with the below expression:

=SUM( DISTINCT
{
<
prospect = {'B', 'C'},
Rolling12turnover = {">=$(=vTurnover12Mon)"},
Rolling12purchasedates = {">=$(=vPurchasedates12Mon)"},

Clientnr = {"=sum(
{<
inv_date={[>=$(=date('$(vFilterdate)'))]}
>}
>
*
<
prospect = {'B', 'C'},
Rolling12turnover = {">=$(=vTurnover12Mon)"},
Rolling12purchasedates = {">=$(=vPurchasedates12Mon)"},

Clientnr = {"=sum(
{<
inv_datum={[>=$(=date('$(vFilterdate)'))]}
>}
turnover)>=$(=$(vturnoverSFilter))"}
>
}
flag_check )

I hope it helps.

[lprill]

Indeed this helps and did the job!  🙂

Thank you a lot!