Sorting out Budget formula

Hi everyone, I’ve checked around but haven’t found the answers I am looking for.
I have a yearly marketing budget board set up, with each month being its own group. I have a column that has actual costs, I wish to subtract this from a base number (150,000). I want this number to be across/shared with all groups.

When I attempt to set a formula, I either get the illegal formula notice or it only subtracts in one column or one group.

Any assistance would be greatly appreciated.

Hi William,

Please post the syntax of your formula.

Want to get rid of the formula column? and write formulas that support multiple lines, variables and can update various columns at once? Take a look at the Advanced Formula Booster at*

I have tried a few variations. Currently using this but it doesn’t achieve what I want

150000 - {Actual}

Thanks for your help!

Hi @Willatwork ,

It supports in my system

For further support contact Us
MSquare Support
Visit us here
Youtube Channel