Niki Nichols 2 Posted February 24, 2022 Share Posted February 24, 2022 I am taking large amounts of raw daily gas volume data and aggregating it to compare against my forecasted volume data. I have made a side-by-side bar chart comparing my actuals vs. my forecast for any given month. I want to make this a combination chart that has a cumulative year-to-date variance calculation that showsTotal Actual Volume - Total Forecasted Volume. Can I do this with a custom expression I've attached a photo below of the data I have. In January, my custom expression should = 1,272,986 - 1,268,523 = 4,463. In February, my customexpression should = 4,463 + (1,290,170 - 2,042,977) = 4,463 + (-752,807) = -748,344. Meaning I am 748,344 units below my forecasted volume so far for the year. Help! Thank you in advance! Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now