Compute sum of two fields filtered based on another field

[Srini96]

Hi,

I have data similar to this,

two fields: quantity and product category

Output should be:

(Quantity(Kits)+Quantity(Supplemental)) / Quantity(instruments)

How can I compute this?

[afv2688 · Accepted solution]

Hello @Srini96 ,

does this work for you?:

If not please give me further details

Regards

[Srini96]

It worked!

Thanks for your help!