Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
i have a request that i'm not able to implement.
I have the following AVG measure with a series of filters included in set analysis:
AVG({<[L2_ft_cumulative_trend_defect.WINDOW_DATE]={">=$(V_MinDate)<=$(V_MaxDate)"},
RELEASE_END_DATE={">=$(V_MinDate)<=$(V_MaxDate)"},
DETECTED_ON_DATE={">=$(V_MinDate1YB)"},
L2_ft_cumulative_trend_defect.CLOSING_DATE={">$(V_MinDate)"}>}
[L2_ft_cumulative_trend_defect.AGEING_CORB]/86400)
Now i have to change only the condition in bold in this way: i have to exclude the rows which have at the same time the fields
"DETECTED_ON_DATE < $(V_MinDate) and L2_ft_cumulative_trend_defect.CLOSING_DATE > $(V_MaxDate)"
I have tried with P() or E() function or +* operators but i receive always errors on set modifier expression.
Could someone please help me to understand which is the right formula?
Thanks a lot,
Raffaello.
Can anyone tell me how i could solve?