Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
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.
Thanks.
count(DISTINCT {$<[MonthLogged_Open_Balance]=[Master Month Date],[Related_Open_Balance]={'YES'}>} %KEY_CaseIDR5_Open_Balance)
May be using if statement
Count(DISTINCT {$<[Related_Open_Balance]={'YES'}>} If([MonthLogged_Open_Balance] = [Master Month Date], %KEY_CaseIDR5_Open_Balance))
May be using if statement
Count(DISTINCT {$<[Related_Open_Balance]={'YES'}>} If([MonthLogged_Open_Balance] = [Master Month Date], %KEY_CaseIDR5_Open_Balance))
Or this
Count(DISTINCT {$<%KEY_CaseIDR5_Open_Balance = {"=[MonthLogged_Open_Balance] = [Master Month Date]"}[Related_Open_Balance]={'YES'}>} %KEY_CaseIDR5_Open_Balance)
Or maybe just using the p() function:
count(DISTINCT {$<[MonthLogged_Open_Balance]= p( [Master Month Date]) ,[Related_Open_Balance]={'YES'}>} %KEY_CaseIDR5_Open_Balance)