Hello Lakshmipathi and Rahul,
Sorry, I didn't post the expression. I have done so now.
For Back Office Administration Salaries (Integral) I am expecting 78,450 to be the result.
Using the calculation you have both suggested, which in my app looks like this:
(sum([Q1 Project Budget]) + sum([Q2 Project Budget]) + sum([Q3 Project Budget]) + sum([Q4 Project Budget]) - sum([Project Expenditure Amount])
/ sum([Project Expenditure Amount]))
I get the following result, which is incorrect.
Is there anything wrong with the calculation? Or do you imagine that the error lies elsewhere?
Thank you for response.
I have tried that calculation and I am still getting the wrong result:
Actual Budget Variance
Back Office Administration Salaries (Integral) 399486 477936 9.76739...
The Actual and Budget are both correct.
But the variance is not. By your calculation it should be 0.196377...
I don't know what's going on. I feel that the data mustn't be loaded incorrectly or else the acutal and budget columns wouldn't be correct. But I also think there's no issue with the expression you've offered. What's going on?