JetReports: Samlet resultat af 2 felter
Nu kommer JetReports*) med hvordan man får det samlet resultat når man beregner
2 felter samme i en record. Læs meget mere om dette nedenfor.
*) JetReports er et rapporteringsværktøj til Navision, som bruger Excel som frontend.
Se mere om Jet Reports her: www.jetreports.com
Solution
You can use a little known feature in Jet Reports with a Navision database to
perform calculations within your Jet Reports formula.
For example, Let's say you need the sum of the Sales Line table's "Quantity" and "Unit Cost" fields, where you multiply the "Quantity" and "Unit Cost" on each record in the table and then sum the result. To accomplish this, you
would add what we call a "calculated" field to you NL("Sum") function.
=NL("Sum","Sales Line","=NF(,""Quantity"")*NF(,""Unit Cost"")")
As you can see by the above formula, the entire calculation must be within Quotes,
and because the calculation is within quotes, we must put quotes around the quotes
for our field names. By putting quotes around our calculation within our Jet
formula, we prevent Excel from trying to evaluate the formula and let Jet Reports
evaluate the calculation instead.
This topic is applies to the Navision Connector only.
Til toppen af siden
Du skal være logget ind før du kan se eller skrive kommentarer til de forskellige indlæg. Klik her for at logge ind, eller oprette en bruger.
