topic Perform a calculation for last 12 months in App Development

Perform a calculation for last 12 months

LEGION — Sat, 16 Nov 2024 20:00:20 GMT

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 🙂

Re: Perform a calculation for last 12 months

martinpohl — Thu, 26 Sep 2019 14:32:46 GMT

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

Re: Perform a calculation for last 12 months

LEGION — Fri, 27 Sep 2019 14:33:00 GMT

Thank you so much, this worked perfectly 🙂