topic Re: Ignoring Filter in App Development

Ignoring Filter

ShaunGinCT — Tue, 13 Oct 2020 19:10:04 GMT

Hi, I'm new to this so please forgive the question:
I have the following expression using set analysis =Only({1<S_START_DATE = {'$(=MonthEnd(Max(Addmonths(S_START_DATE,-1))))'}>} STATUS_VALIDATED) and I have a filter called BP_Business_Partner that I would like to exclude from the calculation, I've seen options for sum, however cannot get this to work on the '=Only()' statement.

Thanks

S

Re: Ignoring Filter

dplr-rn — Tue, 13 Oct 2020 19:37:19 GMT

You are already excluding all filters currenlty. because of the 1.

if you want to exclude just BP_Business_Partner change to soemthing like below (removed 1 and added the part in bold)

Only({<BP_Business_Partner=,S_START_DATE = {'$(=MonthEnd(Max(Addmonths(S_START_DATE,-1))))'}>} STATUS_VALIDATED)