Hi,

Am trying to create a custom formula to determine what % of our pipeline was rolled from one month to the next (ie opportunities due to close this month that were pushed into this month from last month).

Ideally it would be a percentage showing something like

sum of amount where historical close date is less than current month / sum of amount where close date is this month

Would there be anyway to do this without going out to excel?