LYMTD using Year, Month and day

[dushan1987]

Hi,

I want to create Last year Month to Date (LYMTD) using Year, Month and day fields. Please help on this

My expression to LYTM is follows.

Count({$<Main_Year={$(=Max(Main_Year)-1)},Main_Month={"<=$(=Max({<Main_Year={$(=Max(Main_Year))}>}Main_Month))>$(=Max({<Main_Year={$(=Max(Main_Year))}>}Main_Month)-1)"}>}Ref_No)

How can I change this to LYMTD and THMTD?

[PauloHSantos]

you have to pass the field wich the date three times, on charge using the functions Day, Month and Year 


Ex:

 Day("Data_Plano") as dia,
Month("Data_Plano") as mes,
Year("Data_Plano") as ano,

[OmarBenSalem]

try sthing like this:

sum({<Year={"$(=max(Year)-1)"},Month={"<=$(=addMonths(max(Month),-12))"},Day={"<=$(=max(Day))"}>}Value)

[dushan1987]

Hi this is not working. 

My expression to LYTM is follows and it is working correctly. Can I change this to LYMTD?

Count({$<Main_Year={$(=Max(Main_Year)-1)},Main_Month={"<=$(=Max({<Main_Year={$(=Max(Main_Year))}>}Main_Month))>$(=Max({<Main_Year={$(=Max(Main_Year))}>}Main_Month)-1)"}>}Ref_No)

[dushan1987]

Hi,

Can anyone help on this.