Perform a calculation for last 12 months

[LEGION]

Hello, I am struggling with a calculation. I am calculating NETT sales using the following formula: 

(((Sum({<TCODE={'IN'}>} AMOUNT))-(Sum({<TCODE={'CN'}>} AMOUNT)))-((Sum({<TCODE={'IN'}>} PROFIT))-(Sum({<TCODE={'CN'}>} PROFIT))))

This works just fine, but I only want to perform this calculation on data that fall in the last 12 months, my date field is [TXDATE].

Unless this is not possible and someone could please point me in the correct direction.

Thank you in advance 🙂

[martinpohl · Accepted solution]

change to

(((Sum({<TCODE={'IN'}, TXDATE={">=$(=date(addmonths(today(),-12)))"}>} AMOUNT))-(Sum({<TCODE={'CN'}, TXDATE={">=$(=date(addmonths(today(),-12)))"}>} AMOUNT)))-((Sum({<TCODE={'IN'}, TXDATE={">=$(=date(addmonths(today(),-12)))"}>} PROFIT))-(Sum({<TCODE={'CN'}, TXDATE={">=$(=date(addmonths(today(),-12)))"}>} PROFIT))))

Regards

[LEGION]

Thank you so much, this worked perfectly 🙂