February 3, 200718 yr I know this should be very simple to do , but I can't make it work right. I don' want 9.99 showing up in the "Total Buy with Comm" field when I'm using "Sold" field & likewise I don't want 9.99 showing up in the "Total Sold with Comm" field when using the "Buy" field. Please tell me what I'm missing. See attached file Stocks_.zip
February 3, 200718 yr This calculation might help: TotalBuywComm = Case(IsEmpty(Bought) ; "" ; Bought * Cost Per + 9.99) Similarly: TotalSellwComm = Case(IsEmpty(Sold) ; "" ; Sold * Cost Per + 9.99)
Create an account or sign in to comment