Weighted average

[BlackCat]

I have created a "standard" rolling forecast report (Revenue per Month) and now I must create a weighted. What was used previously for the Excel version was: 

return (Math.Round((TotalRev / NumOfMonths) * (Probability / 100), 2)); based on the parameters we are using, I understand that the "opputunity status" will define the probability that the deal/contract will close on, unsure of what logic to create to split them up. 

Any advice is much appreciated.

[Anonymous]

HI @BlackCat,

Please share some dummy data with raw table structure and expected result, it should help us clarify your structure and test coding formula.

How to Get Your Question Answered Quickly 
Regards,

Xiaoxin Sheng