3 Replies Latest reply: Mar 21, 2017 8:39 AM by Stefan Wühl RSS

    Return a full set of dates when no selection is made in set analysis

    Neil Woodham



      In the formula below, I have to make a selection to make it work, what I would like is when there is no selection in Master Month Date for the formula to return the full list of dates, then when dates are selected, just returns those dates.



      count(DISTINCT {$<[MonthLogged_Open_Balance]=[Master Month Date],[Related_Open_Balance]={'YES'}>} %KEY_CaseIDR5_Open_Balance)