Introduktion af NP funktionen
Introduktion af NP funktionen.
Nogen gange har man i Jet Reports*) brug for at udføre bestemte opgaver, såsom
formatering af datointerval, validere en formel eller lave kalkulationer på rækker.
JetReports’-funktionen ”NP” udfører disse opgaver for dig. Det følgende eksempel
formaterer datointervallet: 1/1/04 til 12/31/04.
Se mere om dette nedenfor i vejledningen fra Jet Reports, teksten er på engelsk.
*) Jet Reports er et rapporteringsværktøj til Navision, som bruger Excel som
frontend. Se mere om Jet Reports her:
www.jetreports.com
Introducing the NP Function
Sometimes you need to do certain utility tasks such as formatting a date range,
evaluating a formula or doing array calculations. The Jet Utility function, NP,
will do these tasks for you. The following example formats a date range from 1/1/04
to 12/31/04.
=NP("DateFilter","1/1/04","12/31/04")
This above function will return 1/1/04..12/31/04. The first argument tells Jet
that this NP function will create a date filter that can be used by an NL function.
The second argument is the start date of the filter, and the last argument is
the end date of the filter. See the Calculating Date Filters section for more
details.
The next example evaluates the volatile Now() function, preventing it from slowing
down your report.
=NP("Eval","=Now()")
The above formula will return the current date and time. The first argument tells
Jet that this NP function will evaluate a formula. The second argument is the
formula to evaluate. See the Evaluating Formulas section for more details.
The following example takes the intersection of two arrays.
=NP("Intersect",{"1","2","3"},{"2","3","4"})
The above formula will return {2, 3}. The first argument tells Jet that this
NP function will return the intersection of two arrays. The second and third arguments
are the arrays for which to find the intersection.
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.
