Creo Cabling Repeat Region

Greetings,

Looking for ideas on how to report sum length of cable spool based on custom length per spool segment used in cable harness.

example:

spool A - length=L1, custom_length (driven from relation) =CL1, spool used N1 times in harness.

total length of spool A =?

the problem i have is that I can’t make any relation as there is no way to use rep.qty for cable spools in a harness.

summation function is also not very flexable. I would prefer if it was function then I could create a relation with If (example: if spool a name==A sum).

Is there another simpler way to solve it? 

Practically best solution I found is to generate the table  > export to CSV > make simple excel relation.