dmarshall247 3/13/2024 12:49:53 PM

Price Matrix - What if analysis

I would like to quantify the impact of a potential change to the price matrix to historical billings. In other words, I would like to take my total population of service calls from 2023, sum the total billing amount, and then understand what that billing amount would have been if there was a change to the price matrix. This will allow me to quantify the potential impact of a change to our price matrix. 

Does anyone have advice on how to best accomplish this goal? 

Version: GP 2015, GP 2013, GP 2010
Section: SQL for Beginners


Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
3