Jump to content
We've recently updated our Privacy Statement, available here. ×

Forecast vs Actuals variance


Levi Turner

Recommended Posts

Hi All,

I would like to calculate the variance between our production forecast and actual production as it comes in.

I managed to view this as a percentage using this

[ALLOC_GAS_VOL] / sum([Production Forecast]) OVER ([sTART_DATETIME])

However, I cannot calculate the volume difference on a daily basis

[ALLOC_GAS_VOL] - Sum([Production Forecast]) OVER ([sTART_DATETIME])

I tried this but it doesn't seem to work.

Any ideas out there

Thanks in advance

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...