Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Everybody,
Actually I am using the formala to get Booking for Current Month Current Year and Iam using the below formula
BOOKING CURMONTH TY(Current Year)
=Sum({$<Year={$(=Max(Year))},[Month No]={$(=vCurrentMonth)}>} Booking_Total_Sales)
And for YTD Booking This Year The Formula being used is the below one , I want to know is tihs formula correct , What do we mean by YTD
YTD BOOKINGS TY(Current Year)
=Sum({$<Year={$(=Max(Year))},[Month No]={"<=$(=vCurrentMonth)"},Month=>} Booking_Total_Sales)
Thanks in advance
You can also try
=sum({<Year={$(=Max(Year))},[Month No]={"<=$(=max([Month No]))"}>} Booking_Total_Sales)
Hi Wrestler,
YTD is nothing but gives details about total sales from year starting to the present date.
for your easy explanation try this expression.
=sum({$<year= {'>=$(=Max(YearStart(today())))<=$(=max(monthend(today())))'}>}Booking_Total_Sales)
Regards
Krishna
=sum({<Year={$(=Max(Year))},Transactiondate={"<=$(=max(Transactiondate))"}>} Booking_Total_Sales)
Hi,
YTD means Year to Date, means getting the value from current year start (jan 1) to till date.
Hope this helps you.
Regards,
Jagan.
HI Gowtham thanks for the reply , But i wanted to know is the YTD formula correct ? becuase iam not getting the right vale .
YTD BOOKINGS TY(Current Year)
=Sum({$<Year={$(=Max(Year))},[Month No]={"<=$(=vCurrentMonth)"},Month=>} Booking_Total_Sales)
Can u please help me with this ?