+ Reply to Thread
Results 1 to 2 of 2

sum values in a data group

  1. #1
    BigTim
    Guest

    sum values in a data group

    I would like to find a way to dynamically sum values in a datagroup so that
    if I add or remove items from the the grou the SUM value is updated.

    Example:
    I create a list of items in a price sheet.

    Widget Parts Price$6
    part1 $1
    part2 $2
    part3 $3

    I group them all together:
    data > group and outline > grouip

    I want to sum all the parts so that no matter how many parts I add or remove
    the Price$ will automically update. Currently, if I add or remove parts I
    have to update the SUM() for Price$.


  2. #2
    Dave Peterson
    Guest

    Re: sum values in a data group

    If you put "widget" on each of the part# rows, you could sort your data and do
    Data|Subtotals to get those totals. If you add more parts/assemblies, you could
    resort and redo the data|subtotals.

    BigTim wrote:
    >
    > I would like to find a way to dynamically sum values in a datagroup so that
    > if I add or remove items from the the grou the SUM value is updated.
    >
    > Example:
    > I create a list of items in a price sheet.
    >
    > Widget Parts Price$6
    > part1 $1
    > part2 $2
    > part3 $3
    >
    > I group them all together:
    > data > group and outline > grouip
    >
    > I want to sum all the parts so that no matter how many parts I add or remove
    > the Price$ will automically update. Currently, if I add or remove parts I
    > have to update the SUM() for Price$.


    --

    Dave Peterson

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1