Previous month ending balance as current Month Beginning Balance
Hi I am trying to create a beastmode that takes this months balance and subtract it from last months balance also known as this months beginning balance. sum(CASE WHEN `Month ` = '3' then `AR Balance` else 0 end) - sum(case when `Month ` = 4 then `AR Balance`else 0 end) My problem with the above is the two values aren't…