This website uses cookies so that we can provide you with the best user experience possible. Cookie information is stored in your browser and performs functions such as recognising you when you return to our website and helping our team to understand which sections of the website you find most interesting and useful.
PREVGROUPVAL
PREVGROUPVAL
PREVGROUPVAL is a function used in the reports custom summary formulas to return the value of a summary field from a previous grouping.
PREV GROUP VAL stands for Previous Grouping Value.
This function is often used to analyze the trend of groupings in a report, often visualized in a line chart.
It is also possible to use PREVGROUPVAL to calculate the percent change of one period versus another.
Example: In a report where the opportunities gained per week are displayed, with PREVGROUPVAL function it is possible to calculate and visualize a three-week moving average of opportunity amounts:
(Oppty Sum +
PREVGROUPVAL (Oppty sum, 1) +
PREVGROUPVAL (Oppty sum, 2) ) / 3