Hi,
I would like to know how to get a total amount of two (or more) sub-item values of price and quantity in a formula field.
In Excel you can use the "SUMPRODUCT" function but this is not available in Smartsuite.
I could not find a way to correctly create the sum of these two totals.
800pcs x 240€ = 192.000€ and
400pcs x 89€ = 35.600€
Therefore the total should be 227.600€
If I use the function sum( [subitem].[quantity] * [subitem].[price] ) I get an error message that this is not possible.
