
Example:
date new contracts number contracts Jan 18 10 10 Feb 18 15 25 Mar 18 12 37 Apr 18 9 46
Which formula can I use in the report to get the number of contracts?
7 risposte
No, I'm afraid the PREVGROUPVAL only works up to 12 increments.
Another option here is to use a cumulative line graph - this doesn't require a custom summary formula field at all. Create a line graph chart, use "sum of new contracts" as the Y axis, and check the "cumulative" option.