Calendar selection is not excluding in the formula
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?