Forum Discussion
ChrisSipes
6 years agoQrew Cadet
Yes, you can pull the individual selections out into their own fields in the table, using the formulas, and then do a general sum (which is not considered a formula) on as many columns as you want.
It just duplicates the information in the table so that you can sum it. If I have a person who puts in a number of hours of over time, the formula then copies it over into an overtime column to be summed.
But as in the original statement, I still cannot figure out why some of the reports will stop at 20 entries and the others will go to the full 28. There does not seem to be a setting for this so I am not sure what is creating the behavior. If the reports are only 7 columns of single numerical entries with 2 digit decimal places (no text or anything), that should be nowhere near the 1000 item limit.
It just duplicates the information in the table so that you can sum it. If I have a person who puts in a number of hours of over time, the formula then copies it over into an overtime column to be summed.
But as in the original statement, I still cannot figure out why some of the reports will stop at 20 entries and the others will go to the full 28. There does not seem to be a setting for this so I am not sure what is creating the behavior. If the reports are only 7 columns of single numerical entries with 2 digit decimal places (no text or anything), that should be nowhere near the 1000 item limit.