1 of 1 people found this helpful
Hi Laura, is there any chance that you can post a packaged workbook (with extracted data sources) or a sample of the source data? It's a bit tough to give you specific solutions without either.
However, taking a shot in the dark, you might want to try making your calculated field something like:
SUM([Actual Billings]) - MIN([Budget])
This should work as long there is only one budget value in each cell in your sheet.
Thank you, David!!
I knew it would be a simple answer and my lack of SQL understanding is quite clear so thank you
You're very welcome!