Is there a way to retrieve the product of two numbers using the NL function. For exampled i want the NL function to retrieve the product of (unit Cost * Quantity)
Date
Votes
2 comments
-
Harry Lewis Both yes and no.
If you are using a replicating function, keep in mind that the results of those are always unique.
For example, if my data has the values 1,2,3,1,2,3,1,2,3,1,2,3 and I use an NL(Rows) to show me those, I get the unique values:
1
2
3
(not every value... just the unique)
The same is true if I return multiple fields or the products.
Thus, if my table has Unit Cost and Quantity fields with the following values:
An replicating function which returns just the product of those would return: 6
If, however, I want the product of those two fields for every record in my table, I could have an NL(Rows) function which lists the record key for my table:
=NL("Rows","my_table")and then I could use the NF function to multiply the two fields together
=NF(C8,"Unit Cost")*NF(C8,"Quantity")
If I wanted a SUM of my values - for example, I wanted to list all customer numbers and the sum of all the UnitCost*Quantity values in the Sales Invoice table - the technique would be similar.
=NL("Rows","Customer","No.")and
=NL("Sum","Sales Invoice Line","=NF(,""Quantity"")*NF(,""Unit Price"")","Bill-to Customer No.",C8)I hope that helps.
-
Iborn Scott Thank you. I will give that a try.
Please sign in to leave a comment.