Skip to main content

Multiple values in one field Sum up in another cell

  • March 12, 2021
  • 1 reply
  • 21 views
S
Forum|alt.badge.img+4

if i place a order for example 500 and then it is part shipped in 5 deliveries resulting in 5 invoices . can i have all involves values in one cell ( 100+100+100+100 ) this is then sum into new cell giving me a value of 400. i dont want to be creating new columns for every part invoice . as some order may come in anything up to 10 part shipments

    1 reply

    R
    Forum|alt.badge.img+3
    • Raminder_Singh
    • Participating Frequently
    • March 12, 2021

    Hi @Site_Team,

    I think you are modeling your data wrong. You can do something like this:

    1. Create two tables – Orders and Invoices.

    2. The Orders table links to the Invoices table
    3. Add a roll up field in the Orders table.
    Terms & ConditionsAccessibility statement