Hi,
I have used the NL(Table…. command to build a table containing a few columns. I need to multiply two of the columns together.
Here is the NL(Table) command line =NL("table","Item Ledger Entry",$G$9:$O$9,"Headers=",$G$8:$O$8,"tablename=","Item Ledger Entry","+posting date",B5,"link=",$G$7)
G9 through O9 cells contain the Column values, ie field values, G8 through O8 cells contain the Column Headings.
I have found the following works if I want to multiply one column by a fixed value, but I can not figure out the code to multiply two columns. (this code would be in one cell on row 9)
Formula([@[Maximum Order Quantity]]*2) This would make a new column in the resultant table which contains the value of the Maximum order Quantity X 2.
Can someone help with the syntax to multiply two columns/fields together in the Formula above? I have tried Formula([@[Field 1]] * [@[Field2]]) and other combinations…
Thanks,
Date
Votes
3 comments
-
Jet Reports Historic Posts Official comment FYI - Using the "+ Add Formula" button while building the table is generally going to be your easiest method of doing this.
However, now that the table is built, it's going to be easier probably to just insert the new formula - I tested a table and here's what I found :)
=NP("Formula","=[@[Sales]]*[@[Qty]]") (replace with your two column names)
note that this formula references the Headers, not the field values. So in my case, Qty is actually coming from the "Posted Inv/Cred Quantity" field, but I called the Header "Qty" - so that's what the formula references.
~Heather -
Jet Reports Historic Posts Thank you Heather, that worked perfectly!!!
-
Jet Reports Historic Posts Glad to help
~Heather
Please sign in to leave a comment.