JohnRomano
31 days agoQrew Cadet
Running Total
I want to get a running total of the number of rows in a report. I have a formula that is COUNT([field name]), which returns a value of 1. To get the running total value, do I have to first create a var text query on the field I am counting?
var text QUERY //var text QUERY = "{fid#.}";
Is the Running Total formula: SumValues(GetRecords($QUERY),fid#)
A way to do this without needing a Formula Query is to make use of a summary report which will break on every record. Include a formula numeric field called count with a formula of 1, and then show it on the report and set it to show as a running total.
But if that does not work for you, then we would need to know the sort and filters on the report to help with a Formula Query.