Boxes not minusing?

Need help Database
1

Hi,

The issue is simple atleast in my head. My box isn’t minusing the value from another box. Essentially we have an expenses sheet that has both Work to Work travels and Home to Work travels. For the latter, Home to Work, we need to remove the home to workbase value which is pulled from the users database. For whatever reason, the milage isn’t removing this value, could anyone shed any light? This is the last niggiling thing before I can make it go live for my charity group,

image
image1119×546 55 KB

James

2

Can you give an overview of the data? Mathematically, - - = + … (20 - -20 will be 40 and not 0)

3

Yes that was the issue, I solved it myself by redoing the calculations and keeping it all in one box.