I'm trying to do a basic forecast configuration, comparing with Opp amount total vs forecast. However, I want to have a column showing sum of the opp amount but based on probability %. For exemple, an opportunity valued at 10K with a 50% probability % is valued at 5K, one at 5K at 80% is 4K. So total expected would be 9K. Is there an option for this in the forecast?
Plan be would be to do the calculation in Opp and used that as the amount$. But I know some systems can do the option above OOB, so wondering if I just missed it. Thanks