variance

Hey All, In Excel 2007, I have calculated fields which take calculates a percentage. I added a variance column but the calculated field in the variance column calculates the the percentage of the variance as opposed to the change. Any advice or any recommendations? Thanks, JV SDG

I am trying to come up with a formula to show me in real time where my actuals are against my budget. The problem I am having is, I will be entering actuals as they come in, so I do not have data sets to simply run the percentage off of. I have my yearly budget by month, and a column for the...

I’m trying to add two measures to my report that will give me the following: 1. An actual to budget variance column. The only trick is that it needs to evaluate the account type and if it is a Revenue account, it needs to do Actual minus Budget, but if it is a Cost or Days accounts it needs to...

I have a set of numbers going from oldest to newest in row 1 through 24. I am trying to write a function in VBA to calculate the exponentially weighted volatility of the series of numbers. However, what I have below is not working. Does anyone have any thoughts? The formula for exponentially...

Folks: With VBA in Excel, how can I Identify dates in a range as belonging to the latest 2 quarters in the range and label them in an adjacent column as CQ (Current Quarter), PQ (Prior Quarter) and Other (for dates outside of the last 2 quarters). Attached is a sample result file...

Hello anyone, I have clicked on sooooo many posts regarding 'Pivot Table Calculated Fields" - that I'm getting dizzy and I'm not clicking anymore:eeek: I know it's simple what I want - but I'm still not getting the result I need. Below is my pivot table. I need the pivot table to subtract...

Has anyone done a Cholesky/ variance decomposition before? I am currently doing a project- the idea is to find out the correlation between different stock markets, incorporating directionality. I have stock market returns for around 12 countries and for 3 periods (as I want to do a lag of 2)...

Hello, So I'm using an Olap connection to create some pivot tables for some reporting. I know how to use the topcount function to create a dynamic set which will show, for example, top 30 salesman by sales volume this year. Topcount(Salesman, 30, SalesVolume TY) Then when I use that set...

I would like to find the deviation from a specified point or target that may not be within the data set as an example if given the following data set 50,51,75,72,68,49,81,72,70,68 I may want to find the devaition from "40"

I created a form using the control toolbox and made combo boxes with true or false as the selections. On the master sheet that the form is being linked to the responses are showing as numbers rather than the actual text selection. Is there a way to fix that? Also is there a way to determine a...

Hi! I have a problem with calculating the variance of 2 columns. Column B has a list of values already in it and column A is empty. What I want to do is as a value has been entered in column A, I want to calculate the percent difference between columns A and B. BUT only the % difference...

Hello, I want to calculate the variance between two dates without caring whether its positive or negative. If there is a difference, I want to know the number of days between the two dates. I have a fixed start date in all cases and various end dates where I want to calculate a variance for...

I use a pivot table to summarise data in two columns: Actual and Budget. If "Grand Totals for Rows" under PivotTable Options is checked, the final column displays the sum of the two items for each row. Obviously, adding a budget figure to an actual is meaningless. However, if this column could...