#Expected Revenue Change1 discussing

Seems like if you change the hierarchy the expected field does not calculate new child amounts and then if you recreate the hierarchy it over calculates. I am pretty sure $2000 + $3700 do not add up to $7200. This happens every campaign. Very annoying. Any fixes yet? 

I have tried changing amount in expected revenue in campaign field to trigger an update - does not work. I have tried removing then readding the sub campaign - does not work. HELP!!! 

Hi.  I'm wondering if there is a way to create a formula in an opportunity field that can calculate the currency change in a field from week to week?  For example, if a rep changed the "Expected Revenue" in a seven day period, it would automatically calculate the $ change (increase or decrease) and populate the field "Expected Revenue Change from Previous Week".

Any help is appreciated.