Hello,
I would like to calculate a weighted expected revenue by multiplying "discount_price" by "$quantity" and "$probability" in the revenue line item module and display it in the "best_case" field.
Unfortunately, none of these formulas gives a reasonable result.
$discount_price = currency
$quantity = decimal
$probability = integer
Does anyone have any idea as to what the reason might be?
Thanks!
Steffen
Hi Steffen Scheid ,
While probability is an integer, it represents a percent chance of closing so multiplying by the raw value will result in larger amounts. It's not clear from your post if that is the outcome you are seeing or if there is some other issue. To treat probability as a percent value, I suggest updating the formula to:
multiply(
$discount_price,
$quantity,
divide(
$probability,
100
)
)
Chris
