Summarizing repeating fields?

[cpatubo]

I have an invoice layout that contains repeating fields for quantity, style number and color. What I would like to do is summarize the quantities for each product (by style number) so we can obtain the quantities for the top purchased products in the past six months, and therefore know which products (and in which color) we should bulk purchase.

The trick is (at least to me), since we use repeating fields, the lines vary, and the products are often listed on different lines from record to record. I am unsure of how to create fields on a new layout to summarize by product.

I'm sure there is a simple solution to this problem, I just do not know FM very well.

Thanks in advance!

-Courtney

[Ugo DI LUCA]

cpatubo said:

I'm sure there is a simple solution to this problem, I just do not know FM very well.

Not really Courtney. Since you use repeating fields, this would be a *big* pain in the....

I've lost much of my "repeating fields" knowledge, but IMO, this would be done by investigating each repetition, in each invoice, using a Loop script.

Once you've buil it, go take a cup of coffee and wait for processing...and while you drink it, think of implementing some relationship principles, which would make your life *really* easy.

[djgogi]

Ugo is right, you should really migrate to Invoice--LineItems structure instead on Invoice+RepatedFields

To achieve this simply export data (invoiceID + all repeated fields regarding products)from your current Invoice db to new database with option export each repetition in new record enabled.

BTW, Ugo, I'm struggling to find the "any" key on my keyboard, maybe I should by the french version...

Dj

[BobWeaver]

That would be the "quelque" key.

[cpatubo]

Ugo DI LUCA said:

Once you've buil it, go take a cup of coffee and wait for processing...and while you drink it, think of implementing some relationship principles, which would make your life *really* easy.

LOL... the coffee part sounds splendid.

I'd rant about my client here, but that is a whole new topic/headache. I created their DB to spec (it was efficient when it was first created), then they decide to change their minds every week...

I am all about efficiency, and wish I had a clear idea of what their goals were in the first place...

[cpatubo]

djgogi said:

Ugo is right, you should really migrate to Invoice--LineItems structure instead on Invoice+RepatedFields

Understood. I guess I did it the old fashioned way.

BTW, Ugo, I'm struggling to find the "any" key on my keyboard, maybe I should by the french version...

I've tried...

[Ugo DI LUCA]

Nice one !

Dj, have you tried Ctrl+Alt+Esc

I should have wrote "hit any key", but then I wish I knew that girl called Annie K.

What a hell her life must be...