Following is the example:
created a varialbe: vMaxDate=max(date)
for selcetion fields on the sheet I am using Island table fiels, So I am using the fields in set to compare the payable field.
the following is the expression:
now i want I more condition that the amount following in 0-15, 16-30,31-60,61-90,>90 days with respect to the selection made on the sheet.
(vMaxDate-due_date)>=0 and (vMaxDate-due_date)<=15
Following is the screenshot:
sum of days bucket should be CM.
If I understood, it appears an "Intersection" is needed in the set. Below is my example as I just worked on this yesterday.
Hope it helps.
What this is doing is a "intersection". It states (count (IF the Intersection is >=1 and <=72). (THE * is the intersection of "both SETS".