(Using Navision Database)
I need help with creating a formula please. I am trying to calculate the total outstanding cost on a sales order into one cell (without replicating rows).
The problem is the data resides on individual Sales Lines. Each sales line has a Unit Cost and Quantity. I need to multiply each line's Unit cost by its Outstanding Quantity, and then sum all of the lines into one result field.
The figure I am trying to calculate actually shows in the Sales Order Statistics window on the Invoicing Tab - Cost ($) off of the sales order but I cannot figure out how to translate into Jet.
Thank you.
Lauryn
Date
Votes
4 comments
-
Jet Reports Historic Posts Official comment Hi Lauryne,
Yes, this can be done. Have a try with this:
=NL("Sum","Sales order line", "=NF(,""Outstanding quantity"")*NF(,""Unit cost"")", … filterfields …) -
Jet Reports Historic Posts I'm trying to find my example of this, but I can't. So I'm going off the top of my head, but something like this perhaps:
C3 = formula to retrieve Sales Order No.
C4 = nl("Sum","<table>",nf("Unit Cost")*nf("Quantity"),"No.",C3)
Where <table> could be Sales Invoice Line, Sales Line, etc. Give it a try and let me know if I'm even close to what you're trying to do.
cheers -
Jet Reports Historic Posts I probably should have looked harder for my example… Thanks hans!
-
Jet Reports Historic Posts Thanks very much. This worked perfectly.
lauryn
Please sign in to leave a comment.