Forum Discussion
QuickBaseCoachD
7 years agoQrew Captain
@Avi. I don�t think your solution will work. The problem is that the summary report only summarize his records that exist and is not summarize records they don�t exist.
So one solution could be to introduce a set of dummy records contrived to sort stay to the very bottom of the list which would show up for a zero value in all months. So you might need to load in 12 dummy records.
If you report is currently counting the number of items, you can make a formula feel that would calculate to 1 for all of the real records but would calculate to a zero for the dummy records.
Then rather than counting the record you would do a summary total of that account field where each record would have the value of one except for the dummy record which would have a value is zero.
Then your summary report totals would still be correct as the final row in the summary report would have zeros all the way across it but in doing so would force all the months from January to December to appear.
So one solution could be to introduce a set of dummy records contrived to sort stay to the very bottom of the list which would show up for a zero value in all months. So you might need to load in 12 dummy records.
If you report is currently counting the number of items, you can make a formula feel that would calculate to 1 for all of the real records but would calculate to a zero for the dummy records.
Then rather than counting the record you would do a summary total of that account field where each record would have the value of one except for the dummy record which would have a value is zero.
Then your summary report totals would still be correct as the final row in the summary report would have zeros all the way across it but in doing so would force all the months from January to December to appear.
QuickBaseCoachD
7 years agoQrew Captain
I do not know of a solution which would not create some "noise" in that summary report. All I can do is to offer suggestions to minimize the noise.