Another question:
$ goal | $ actuality | $ exceeded or missed by
Example
$100 | $90 | -$10
how can i create a formula for my “$ exceeded or missed by” column so that it takes the “$ actuality” column and subtracts the “$ goal” from it?
I have tried the obvious: (Table Name.$actuality) - (Table Name.$goal)
but it did not work