Hi All,
Please check the below expression. In this I have excluded the Year, Month and Date Selections in Set Analysis. But it is not working. Could someone please let me know if I have to specify the exclusion elsewhere in the expression.
Sum({<[Year=, Month=, Date=>}Aggr(If([First Hearing Session Date] < (vMinDate) and
([Judgement Date] >= (vMinDate) or [Judgement Date] = 'NA') and
not match(
//Variable Start
Aggr(FirstSortedValue(distinct{<[Session Date] = {"<$(=Min(Date))"}, Year=, Month=, Date =,
[Session Type] = {'Val1','Val2'}>}
[Type], -[Session Date]),[Case ID])
//Variable End
,'v1','v2','v3','v4') and
(Status <> '2'),1,0),[Case ID]))
or is there a way to compare result of a variable(which will alter based on selection) with set of values in set analysis?
eg : Sum({<$(vTypeVariable) = {'t1','t2'}>}Sales)
Thanks,
Girish