Chance of revenue =  (probability/100) x deal value

This calculates but  I expected that by then changing the stage, the probability would change and in turn my chance of revenue value would as well

Clearly the change in stage does not flow through to the formula as the returned value does not change

Any suggestions?

(I am using a formula to do this rather than the default fields as I am using a pick list to generate deal amount)

Thanks