YTD Calculation

[#1]

HI Guys

Iam using the below formula to calculate sum of YTD, and it is working fine

=Sum({$<FiscalYear={$(=Max(FiscalYear))},[FiscalMonth]={"<=$(=max([FiscalMonth])-1)"},FiscalMonthName=>}(Billing_Sales_Value-Booking_Sales_Value))

I just want to know is it giving me the ytd of both Billing _Sales_Value -  YTD of Booking_Sales_Value .

Or just it is giving me the YTD of Billing _Sales_Value

Thanks in advance

[AbhijitBansode]

it will give you YTD of (Billing_Sales_Value-Booking_Sales_Value)

[tresesco]

It follows simple mathematics and hence, you get 'ytd of (Billing _Sales_Value - YTD of Booking_Sales_Value )'

[#4]

Thanks for the reply

It means it will give the YTD for Booking_Sales_Value and as well as YTD Billing Sales _Value right ?

[Anonymous]

Hi,

it will give you year to previous month of (Billing_Sales_Value-Booking_Sales_Value)

not YTD

(=max([FiscalMonth])-1) - this query selects data for previous month

for YTD give(=max([FiscalMonth]))  remove -1