Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
Need a help in set analysis.
we have a scenario
Table1:
Load * inline
[
D1 , Key
5/1/2015 , A
6/1/2015, B
7/1/2015, C
];
And we have a calendar linked which has all dates.
Need count(key) where (date selected - D1)>5
Please help with the set analysis expression for this.
Suppose date selected is 11/1/2015, count of key is 1, as
11-5=6 for A
11-6 = 5 for B
11-7 = 4 for c
Only for A, the difference is >5.
Thanks.
Hi,
Try like
count(if(interval(date_SelectedField-D1,'D')>5),key)
Regards
Hi,
Try like
count(if(interval(date_SelectedField-D1,'D')>5),key)
Regards
Hi,
Try this expression
Count(if(interval(GetFieldSelections( YourCalendarDate )-D1,'D') > 5,Key))
Regards
Anand