AnsweredAssumed Answered

Sum fields in a portal based on ID

Question asked by goldencode on Jun 18, 2018
Latest reply on Jun 19, 2018 by philmodjunk


Hi everyone,

 

Lets get straight to it

 

I would like to sum the quantities of added products to an invoice of the same ID in the portal

 

To make it more clear, so it would be like Sum( Invoice::Product_Qty ) .. This way it will sum all products with different IDs but my goal is to sum the product quantities based on their unique product IDs

 

Maybe i should use ExecuteSql? If it is the only way then how?

 

 

At the end thank you so much for any help you provide, i do really appreciate the little

Outcomes