Hello!
In the attached screenshot I've been trying to get it such that I can either change the 'Totals' column into a column which contains the delta between the two sales year, or add a column that does that.
Is there any way on a summary report to add a column that looks at the difference between two previous columns?
Yep - Quickbase has Summary report formulas where you can do things like this. Here is the documentation that hopefully can get you started otherwise I can help if you need specific guidance.
https://helpv2.quickbase.com/hc/en-us/articles/4570403356564-Summary-report-formulas
Thank you for the reply!
I think something like Summary Formulas is what I'm looking for, unfortunately the values I'm attempting to compare and find a delta for are the same Field, just summarized and grouped by Year in the screenshot above.
Is there anyway to use Report or Summary formulas to be able to one group of summarized Field information from another in the report?
I have done in a similar situation is to make two helper fields at the detail record level like this.
field 1
IF([Year] = "CY22/SY23", [Net Ordered Units],0)
field 2
IF([Year] = "CY23/SY24", [Net Ordered Units],0)
Then put those two separate fields to be summarized on your summary report and then use summary variables and summary formulas.
It's a bit kludgy but it will work.
