Comments
-
That allowed me to compare current quarter against previous, but not sum them and display rolling totals. Example of what I'm attempting to do: Period Amount Type TTM Q4-2021 7.15085 Recurring Q1-2022 8.15914 Recurring Q2-2022 15.32489 Recurring Q3-2022 9.50269 Recurring 40.13757 Q4-2022 12.63425 Recurring 45.62097 Q1-2023…
-
Thank you! This worked.
-
Thanks Michelle! I do have a list of all possible values - 19 to be exact. Having trouble re-concatonating after the extrapolation (I think) because of the null values? I Just keep recieving a syntax error. Using: CONCAT(`CPL 1`,`CPL 2`,`CPL 3`,`CPL 4`,`CPL 5`,`CPL 6`,`CPL 7`,`CPL 8`,`CPL 9,``CPL 10`,`CPL 11`,`CPL 12`,`CPL…
