This content has been marked as final. Show 2 replies
Need a help in set analysis.
we have a scenario
Load * inline
D1 , Key
5/1/2015 , A
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.