Negative Value is adding on to Positive value for some reason?

[Deano478]

Hi Community,

This might be a super simple one but my maths is simply failing me big time.

Basically I have two values a negative value and a positive value and I need to subtract the negative value from the positive value, however when I subtract them the negative value is being added on to the Positive value and increasing it.

I have no idea how to fix this so any help would be terrific,

cheers everyone

Here is a a sample of the two values and the formula I have tried to use:

Formula: [Value 2]-[Value 1]

Code	CompanyName	Value 1	Value 2	Total	2021
ABC021_C	Test Company Limited 1	-750	2000	2750	TRUE

[BS_THE_ANALYST]

@Deano478 sorry I replied already 😂. Hopefully it all makes sense!