Can someone supply the proper syntax for calculating both budget and schedule variance?
Need to determine the budget percentage variance bewteen estimated and actual costs. In addition, need to do someting similiar for project schedule variance. Need the exact syntax for a column formula, apparently I am doing something wrong.
Answers
-
Hello @Jon Mallek ,
If I understand correctly, you'd like the percentage difference between two values. Please see my example below:
This is the Formula I used: =([Actual Cost]@row - [Estimated Cost]@row) / [Estimated Cost]@row
Here are the results:
Let me know if you have any questions!
Regards
Sean
-
Should @row be @row5 if the calculation is being done on the 5th row? I still can't get it to work, keep get #Unparseable. I also want to calculate the percentage variance between the two numbers.
-
Hey @Jon Mallek ,
You could use =([Actual Cost]5 - [Estimated Cost]5) / [Estimated Cost]5 for the 5th Row, but @row can be copy and pasted into each cell required, and it will calculate the variance of the numbers on the row that its being used on.
You may be getting unparseable as the Column Names I have in my Example may differ from what you currently have within yours.
Regards
Sean
-
That's what I thought at first, but I actuallly changed the column names to match yours. Very strange....
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.7K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 468 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!