Hi there, Is there any way to multiply two lists (quantity*price)?
There are three properties ‘quantity’, ‘product_id’,‘price’ in ‘purchase’ event.
- quantity : (from GTM data layer)
- data type : list
- example : [1,3,1]
- product_id : (from GTM data layer)
- data type : list
- example : [‘P1’, ‘P3’, ‘P4’]
- price : (lookup table, key=product_id)
so i made custom event sum(quantity*price) to calculate the revenue per user.
but values are always undefined.
Is there any way to multiply two lists (quantity*price)?