-
Dynamic Date Field with Over Function and Balance Forward Question
Please see the attached video to better explain what we are trying to accomplish. https://youtu.be/jOZmhUea6KE. Beast Mode Used: SUM(SUM((CASE WHEN `PERIOD` = '2016-01-01' THEN (`Beg Balance`+`AMOUNT`) ELSE `AMOUNT` END) ) ) OVER(ORDER BY `PERIOD`) We currently have a balance sheet account where we are trying to calculate…
-
Year over Year Value Change
I have a card that shows year over year value. However, I want to show year over year change (i.e. 2015 to 2016, 2016 to 2017, etc.). Attached below is a screenshot of my current card. I want to add a line showing the dollar change year over year.
-
Dynamic Date Field with Over Function and Balance Forward Question
Please see the attached video to better explain what we are trying to accomplish. https://youtu.be/jOZmhUea6KE. Beast Mode Used: SUM(SUM((CASE WHEN `PERIOD` = '2016-01-01' THEN (`Beg Balance`+`AMOUNT`) ELSE `AMOUNT` END) ) ) OVER(ORDER BY `PERIOD`) We currently have a balance sheet account where we are trying to calculate…