Forum Discussion

kennoe's avatar
kennoe
Helper I
8 years ago
Solved

Calculating value from table values

I have created a table and need a formula to calculate the values in a vacant column. The relevant columns in the table are shown below. I want to calculate the Variance, which is the the difference ...
Need Help
  • kennoe's avatar
    kennoe
    8 years ago

    Thanks Thejeswar

     

    I am happy with the result. We round the variance value to a whole number, so it will be 0% in this case, which is what would be expected.

     

    Cheers

     

Thejeswar's avatar
Thejeswar
Super User
8 years ago

Hi kennoe,

Went through your data. Can you also tell what is the expected Vaiance for your Identifier 5?

 

As far as I tried, the value comes as 0. But if you look deeply, it is not 0%. It is something like 0.00070581%

 

Going by the formula which you have given, for Identifier 5,

Budget = 151644

actuals + Forecast = 127569+14112 = 141681

 

The Variance Calculation would be something like this

 

(151644/ 141681) / 151644 = 0.0000070581

 

When multiplied by 100, it becomes 0.00070581%

I am afraid going by this formula, even excel is going to give the same value.

Click here for the PBIX with the same shown

 

Clarify if I am missing something here...?

kennoe's avatar
kennoe
Helper I
8 years ago

Thanks Thejeswar

 

I am happy with the result. We round the variance value to a whole number, so it will be 0% in this case, which is what would be expected.

 

Cheers