Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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?
Try with
COUNT ( {$< ID_TIE_DATE# = { " >= $(vDateFrom) <= $(vDateTo) " } >} DISTINCT ACCOUNT_ID)
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)
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?
Thank you, I think this worked!
I was expecting to show a relative % considerating the ID_TIE_DATE# field from my Master Calendar.