Question about 'totals'

[Gromit137]

Hope this isn't a dumb question. I know how to get summary info...but I need to get the total of items of the same named field. Example... field 'item' has 3 records with the term 'guitars'. One record has 2 in the quantity # field, another has 3, and another has has 4...so the total would be 9 guitars. Three records with 'guitars' entered in 'item' field...how do I get the summary total of JUST guitars...not all others...pianos,etc. Does this make sense? Thanks.

[Fitch]

I'll assume this is an invoice or PO and we're talking about related line items.

You could for example make a relationship that includes both invoiceID::invoiceID, and globalItem::item. Here "globalItem" is a global field of type text. Let's call this relationship theItems.

You could use a script to set globalItem to "guitars" and then get the total with Sum(theItems::quantity).

A different way to do it would be to make a calculated number field in the related file like so: Case(item="guitars";quantity). Let's call this field guitarCalc.

You could then use your existing invoice>line items relationship to get Sum(line items::guitarCalc).

Hope that helps.