Variance Calculation

[#1]

Hello All,

I fear that this is a rather foolish question, nevertheless...

I have the following table:

I would like to calculate and so I am using the following calculation:

(sum([Q1 Project Budget])+sum([Q2 Project Budget])+sum([Q3 Project Budget])+sum([Q4 Project Budget])) - (sum([Project Expenditure Amount]))

However, it is not yielding the correct answer. Please can someone tell me why this is the case?

Thank you all in advance,

Alison

[#2]

Hi,

OK no worries. Thank you for your help regardless.