I'd build off that current calculation and do a comparison for max date to min date to get the number of months difference to use for each row. The value in the calc could be set to if datediff('month',date,date) is >12 then 12 else datediff('month',date,date). Then use this value in your place of your 12 there. Maybe??
Thank you Patrick, I will give that a try.
Sr Analyst, Sales Op Management - Sustainable Technologies
15 Hampshire Street Mansfield, MA 02048
508.261.8148 dir | 844.COVALUE field service
image003.png 15.6 KB
I am struggling with this calculation. Do I need to determine the months difference outside the calculation? I have hundreds of rows. or will what you provided me with below, determine the months difference?
datediff('month',date,date) is >12 then 12 else datediff('month',date,date)
The main thing is out of these hundreds of rows, all of them have different months sales, they are not all the same.
I am very new to these complex calculations and would appreciate any further insight to this!