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.