What you are talking about is a weighted result. This can be done with the following sample formula:=NL("Sum";"Purchase Line";"=Local(NF(,""Quantity"")*NF(,""Unit Cost""))";"Document Type";"Invoice")Only in your case you would do Height * Width instead of Quantity * Unit Cost.
Date
Votes
1 comment
-
Jet Reports Historic Posts Dear all,
is it possible to calculate within one JetReport request and summize the result.
For instance there are table entries containing the fields "Quantity X" and "Quantity Y" which mean X: # of sold articles and Y: length of article in meters. I want to calculate the total length of sold articles - X * Y.
Taking sum of X multiplied by sum of y will lead of course to a wrong result, as well as only sum of Y (X is often but not allways 1). So I have to multiply each entry first and then summarize.
But how to do this?! :)
Please sign in to leave a comment.