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 |
Solved! Go to Solution.
@Deano478 sorry I replied already 😂. Hopefully it all makes sense!