Set Analysis Expression

[#1]

Hello,

I have the following Set Analysis:

COUNT(DISTINCT ACCOUNT_ID)

/

COUNT({1<ACCOUNT_ID>}DISTINCT ACCOUNT_ID)

What I want is to add this (the underlined) to both COUNT functions:

COUNT ({$<ID_TIE_DATE#={">=$(='$(vDateFrom)')<=$(='$(vDateTo)')"}>} DISTINCT ACCOUNT_ID)

Do you know how could I do it?

Thank you!

[its_anandrjs]

Try with

COUNT ( {$< ID_TIE_DATE# =  { " >= $(vDateFrom) <= $(vDateTo) " } >}  DISTINCT ACCOUNT_ID)

[#3]

Thanks, but how do I apply the ID_TIE_DATE# over the 2nd COUNT?

COUNT ({$<ID_TIE_DATE#={">=$(='$(vDateFrom)')<=$(='$(vDateTo)')"}>} DISTINCT ACCOUNT_ID)

/

COUNT({1<ACCOUNT_ID>}DISTINCT ACCOUNT_ID)

[its_anandrjs · Accepted solution]

Try

COUNT ( {$< ID_TIE_DATE# =  { " >= $(vDateFrom) <= $(vDateTo) " } >}  DISTINCT ACCOUNT_ID)

/

COUNT( {1<ACCOUNT_ID=, ID_TIE_DATE# =  { " >= $(vDateFrom) <= $(vDateTo) " } >}    DISTINCT ACCOUNT_ID)

What is your expected output?

[#5]

Thank you, I think this worked!

I was expecting to show a relative % considerating the ID_TIE_DATE# field from my Master Calendar.