MTD Data is Correct but YTD value is getting wrong.

md_talib — Wed, 14 Jun 2023 05:15:23 GMT

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.

topic MTD Data is Correct but YTD value is getting wrong. in App Development