Hi, here is a new problem for you.

I would need to automatically assign the rental value of the various costume parts, which can always be different in both number and “weight” by calculating the sum of the weights of the various pieces of each costume, and then relating the weights to both the number of pieces and the total value of the entire costume. The same piece will have a different rental value if it belongs to a costume that has two pieces, rather than one consisting of four pieces.

Here is an attached example of the kind of result I would like to achieve.

name | group | weight (1-100) | equals sum | totale costume | weighted values |
---|---|---|---|---|---|

costume01_giacca | costume01 | 25 | 40 | 1000 | 625 |

costume01_pantaloni | costume01 | 10 | 40 | 1000 | 250 |

costume01_cappello | costume01 | 5 | 40 | 1000 | 125 |

costume02_giacca | costume02 | 20 | 100 | 1500 | 300 |

costume02_pantaloni | costume02 | 35 | 100 | 1500 | 525 |

costume02_cappello | costume02 | 20 | 100 | 1500 | 300 |

costume02_scarpe | costume02 | 25 | 100 | 1500 | 375 |

costume03_giacca | costume03 | 15 | 30 | 2000 | 1000 |

costume03_pantaloni | costume03 | 15 | 30 | 2000 | 1000 |

(I tried to work on it in airtable but it is very difficult for what my knowledge is, in the program the sum of the values of the grouped elements is automatic, but basically you cannot use it to do calculations, except by using automations and complex scripts)

Thanks in advance to everyone