Calculation works but:

[Kicker3]

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

[datalink]

This calculation might help:

TotalBuywComm =

Case(IsEmpty(Bought) ; "" ; Bought * Cost Per + 9.99)

Similarly:

TotalSellwComm =

Case(IsEmpty(Sold) ; "" ; Sold * Cost Per + 9.99)

[Kicker3]

Thanks Works Great

I knew it was simple, but I just couldnt get it.