Hello,
Suppose we have a table with
*Id *FieldA *FieldB *MANUAL CALCULATION A/B
1 10 1 (10/1) = 10
2 20 5 (20/5) = 4
3 5 5 (5/5) = 1
The column MANUALCALCULATION is not on the NAV, bu I want the total sum of that information.
So I would need something like:
NL("Sum";"Table";"FieldA"/"FieldB")
But it seems no formula is allowed on field. How can I get the number wth NL formula? :roll:
Thank you!!!!
Date
Votes
3 comments
-
Jet Reports Historic Posts Have you tried something like this?
=NL("Sum","Table","=NF(,""FieldA"")/NF(,""FieldB"")") -
Jet Reports Historic Posts It works great!!!! Thank you!!!
-
Jet Reports Historic Posts Hi again,
what HPDesk said worked great, but now I have a similar problem but more complicated:
TABLE: SALES
*Nº
*Quantity
*Base Unit of Measure: units
TABLE: UNIT OF MEASURES
*Nº
*Measure (example: unit & pallet) I have these two measures
*Unit (example: 1 & 100) These are the units in a unit or a pallet
I want to get the number of pallets I sold, but each product has a different quantity in boxes or pallets.
SO should be something like:
NL=("Sum","Sales","=NF(,""BaseUnitOfMeasure"")/NL(,"UnitOfMeasure","Unit","Measure","pallet","Nº","=NF(,""Nº"")))
Here I take the units sold Here I need to take the pallet unit for this product
I see it doesn't work when I insert an NL there…. also if it is a way to make it works I don't know if the =NF(,""Nº"") will work there to get the nº of the product.
I'm getting crazy :?
Any suggestion?
Please sign in to leave a comment.