Subtraction equation

Kate Condon

Hello,

I want to subtract from a fixed amount, the formula I continue to receive an error message for is:

=SUM((20) - [Slippers:Slippers])

All of these equations are being calculated in a sheet summary.

John_Foster

Hi @Kate Condon,

I think the issue is that there is no calculation on the Slippers values. Try the following and see if this resolves the issue.

=20 - SUM([Slippers:Slippers])

John