n____l____

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…

in Creating a Rolling 4Q Total Comment by n____l____ December 2023

Thank you! This worked.

in Removing Duplication and Ordering Objects within a Concatonated Field Comment by n____l____ December 2022

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…

in Removing Duplication and Ordering Objects within a Concatonated Field Comment by n____l____ December 2022

nl Member

Comments

n____l____ Member

Comments

nl Member