Formula Problem

[GregRyder]

Hi

I am trying to calculate the month to date sales for last month. I am using an auto calendar.

here is my Formula

Sum({<[TXDATE.autoCalendar.MonthsAgo]={1}, TCODE={'IN'}, [TXDATE.autoCalendar.Month] ={"<=$(=Num(Month(Today()))) "} >} AMOUNT)
-
Sum({<[TXDATE.autoCalendar.MonthsAgo]={1}, TCODE={'CN'}, [TXDATE.autoCalendar.Month] ={"<=$(=Num(Month(Today()))) "} >} AMOUNT) 

[GregRyder]

Hi Daniel,

You were correct and the formulae now works as expected, I just one small question now.

The data I have is always 1 day old so as of today the 06/10/206 I only have the data until 05/10/2026 so I want to compare last year October for the same period and not include the data from 06/10/2025.

Hope this makes sense.

Thanks 

Greg

[GregRyder · Accepted solution]

Hi Daniel,

I work it out.

Thanks for all the help