Formula for subtraction not working?

Another question:

$ goal | $ actuality | $ exceeded or missed by
$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

Oh, well i fixed it by simply not including the name of the table before name of the column, which i find odd since that is how i would normally express them in a formula.

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.