<div>
Thank you I figured it out in the meantime using the same method. &nbsp;Here's the formula I used. <br />
<br />
@Sum(@TextToNumber(@DbLook<wbr />up(&quot;&quot;;&quot;&quot;;&quot;<wbr />ItemLU&quot;; Cart_OrderID; 4))) - @Sum(@TextToNumber(@DbLook<wbr />up(&quot;&quot;;&quot;&quot;;&quot;<wbr />ItemLU&quot;;Ca<wbr />rt_OrderID<wbr />;5)))<br />

</div>


Thank you I figured it out in the meantime using the same method.  Here's the formula I used.

@Sum(@TextToNumber(@DbLookup("";"";"ItemLU"; Cart_OrderID; 4))) - @Sum(@TextToNumber(@DbLookup("";"";"ItemLU";Cart_OrderID;5)))


<div>
<div class="content wysiwyg-content">
I am working on a back-end note database that will generate a packing slip. &nbsp;I will be pulling in item documents with a dblookup based on a common order id. &nbsp;This works ok, but I'd like to calculate the total price of all items. &nbsp;Is this possible when the total is on one form and the prices are on individual item documents? &nbsp;I was thinking of an @Sum of a dblookup?<br />

</div>
</div>


I am working on a back-end note database that will generate a packing slip.  I will be pulling in item documents with a dblookup based on a common order id.  This works ok, but I'd like to calculate the total price of all items.  Is this possible when the total is on one form and the prices are on individual item documents?  I was thinking of an @Sum of a dblookup?


Compute a total dollar amount on an order form where items use a different form

Lotus Software produced the Lotus 1-2-3 spreadsheet program, and later developed Lotus Notes, a groupware and email system. Following its acquisition by IBM, the Notes and Domino client/server collaborative platform were expanded to include functions such as email, calendars, to-do lists, contacts management, teamrooms, discussion forums, file sharing, microblogging, instant messaging, blogs, and user directories. IBM also release SmartSuite, a comprehensive office suite, and followed that with Symphony, unrelated to the Lotus suite of the same name.