Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have to calculate the sum of MTD and YTD.
MTD data is correct for each month but in YTD value is wrong.
here is my expression
Num(alt(Sum({< STAT_FLAG={"BUDGET"},[Fiscal Month],[FY Year Name],BUSINESS_DATE,
Posting_Date={">=$(vCalMinDateYtd) <=$(vCalMaxDate) "} >} NO_OF_GUEST_STAYED) /BUD_Day_Target,0),'#,##0')
here BUD_Day_Target is the no. of days in the month.