Dynamic Annualized Number- Using Hard Coded Number Now for the Month
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…