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