I have a beast mode that is currently using a hard coded number for the month (i.e 7 for July) and I want to make it dynamic to update each pervious month we close. Below is my current beast mode, which works but is not dynamic:
(SUM(case when `Period`>='2019-01-01' and `Period`<'2020-01-01' and `Ledger Type`='AA' and `Suppress Plan Month`='No' then `Amount` else 0 end)/7)*12