Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi there,
How can i convert below expression into Set Analysis ?
COUNT
(
DISTINCT
IF(
(
SC_ENABLED_STATE = 1 or
(DATE(SC_LAST_CANCELLED_DATE,'MM/DD/YYYY') = '' AND SC_ENABLED_STATE = 1) OR
(DATE(SC_LAST_CANCELLED_DATE,'MM/DD/YYYY') <= DATE(SC_START_DATE,'MM/DD/YYYY') ) OR
(DATE( SC_LAST_CANCELLED_DATE,'MM/DD/YYYY') >= DATE(v_EndDate,'MM/DD/YYYY')) or
(DATE(SC_LAST_CANCELLED_DATE,'MM/DD/YYYY') = '' AND SC_ENABLED_STATE <> 1 AND DATE(SC_MODIFY_DATE,'MM/DD/YYYY') >= DATE(v_EndDate,'MM/DD/YYYY') )
)
,ID))
Many Thanks
Sanket
Thank you for analysing whole things.
But for this KPI calculation we are using DATEUID fields and NOT any variables.
Here we need to compare 2 dates which are coming from same model with same format = YYYYMMDD.
Please don't refer any variable for this issue. I am using variables for other KPI calculation.
Can you send me test application with generating 2 dates comparison with set analysis. That would be really helpful to me ?
Many Many Thanks
Sanket
I don't that.. but we can create such using field for any implement ion.
Hi,
see below thread
Regards
The if statement you are using, you are using it in a chart with Vendor Name as the dimension right?
Can you try this:
Count({<PARTNER_ACCOUNT_ID = {"=Num(PC_FIRST_ACTIVATED_DATE) <= Num(SC_LAST_CANCELLED_DATE)"}>} PARTNER_ACCOUNT_ID)
Perfect !! You are Great
Its working man....
Let me try with my other clauses and get back to you in case anything.
Many Many Thanks
Sanket
Awesome. I think I understood why it wasn't working before. The uniqueness was coming from Partner_Account_ID and not Vendor Name.