Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
if(GetSelectedCount([Month])=0 and GetSelectedCount([Fiscal Year])=0,
num(sum({<calendar_current_month_offset={'$(vDefaultMonthABCInventory)'}, month_end_metric_date_key={'20161031'}>}forecast),'#,##0'), The set analysis should be when the month_end_date_key = month_end_metric_date_key
num(sum({<calendar_year_month = {'$(=Max(calendar_year_month))'}>}forecast),'#,##0')
)
I am not sure if my understanding is correct? When you say the date you need is 20161031 does it mean you are looking for the current month end date
Yes True ..Current Month
Ca you please try the below
Let varMaxDate = Date(MonthEnd(today()),'YYYYMMDD');
You Can use monthStart , Month End Function