Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi there,
I want to today date in my formula instead of 01/05/2016
(sum({<TYPE={'ACTUAL'},BUSINESS={'NEW','EXPANDED'}*P([BUSINESS]),MONTH={'<=01/05/2016'}*P(MONTH)>-<CLIENT={'NEW CLIENTS','EXPANDED CLIENTS','FORECAST ADJUSTMENT'}>}AMOUNT))/1000
Thank you
I hope that MONTH field is actually a date field, else this is not going to work. If it isn't use a date field here
(Sum({<TYPE={'ACTUAL'},BUSINESS={'NEW','EXPANDED'}*P([BUSINESS]), DATE={"<=$(=Today(), 'DD/MM/YYYY')"}*P(MONTH)>-<CLIENT = {'NEW CLIENTS', 'EXPANDED CLIENTS', 'FORECAST ADJUSTMENT'}>}AMOUNT))/1000