Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)