Create a Comparison Column in Summary Reports
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 ...
Forum Discussion
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
------------------------------
Chayce Duncan
------------------------------
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?
------------------------------
Blake Burns
------------------------------- MarkShnier__You
Qrew Legend
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.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------Similar to Mark if you're using the summary report to group by something like year the best approach is to try and chunk that grouping into individual fields like Prior Year v Current Year and build your summary report off of that, then leveraging the summary report formulas to calc the difference.
------------------------------
Chayce Duncan
------------------------------
