Skip to main content
Tilo Vieten ha fatto una domanda in #Reports & Dashboards

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
  1. 7 set 2018, 14:26
    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.

     

    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.

     

    Cumulative Chart
0/9000