Your expression seems correct. Did you define it as the calculation for a field of type calculation or for a number field with this calculation as the auto-entered calculation?
It should be used with a field of type calculation.
Thank you! That was it! I was using an auto enter instead of calculation field. Don't know what I was thinking. Curious as to why it wouldn't work with an auto enter though. Thanks again,
Auto-entered calculations cannot update when the value that is changed does not come from a field in the same record.