AnsweredAssumed Answered

How to deal with negative auto entry results when the calculation cycle is incomplete?

Question asked by Chaz on Oct 20, 2016
Latest reply on Oct 20, 2016 by user19752

I'm not sure if I'm asking this question correctly. I am an investor and have created a database to keep track of my investments. There is also a summary layout that can be printed for income tax purposes.  For example, "days held" field has a -734499 entry because I haven't sold the stocks yet.  To complete the calculation cycle I would have to sell the stock(s) then the "days held" would give an accurate entry.  This entry should be zero and when the stock(s) are sold the entry should give the number of days the stock was held before they were sold.  It's really not a big deal, but it would be nice to have zero instead of a negative number.  My question, is there a way to deal with these negative auto entries before the calculation cycle is completed?

Outcomes