Page History
FUNCTIONS USED IN REPORTS AND FORMS
LIST OF FUNCTIONS
1‐ MIN(number, number)
2‐ MAX(number, number)
3‐ MOD(number, divisor)
4‐ DIV(number, divisor)
5‐ ABS(number)
6‐ VAL(text)
7‐ DATE(day, month, year)
8‐ AFTER(days, year)
9‐ DAYS(firstdate, lastdate)
10‐ DAYOF(date)
11‐ MONTHOF(date)
12‐ YEAROF(date)
13‐ WDAYOF(date)
14‐ ROUND(number)
15‐ TRUNC(number)
16‐ ERATE(date, currency)
17‐ CREATE(date, base curr., base rate, dest. curr)
18‐ STRPOS(search string, string)
19‐ FLOOR(number)
20‐ CEIL(number)
21‐ FRAC(number)
22‐ EXP(number)
23‐ LN(number)
24‐ POWER(base, exponent)
25‐ SQR(number)
26‐ SQRT(number)
27‐ COS(number)
28‐ SIN(number)
29‐ TAN(number)
30‐ STRLEN(text)
31‐ WEEKNUM(year start, first week, date)
32‐ STR(number)
33‐ DATESTR(date, format)
34‐ MONTHSTR(month)
35‐ WDAYSTR(weekday)
36‐ NUMSTR(number, decimals, format)
37‐ TIMESTR(time, format)
38‐ RESXSTR(list resource, tag)
39‐ RESSTR(string resource)
40‐ CRESSTR(list id., tag)
41‐ SUBSTR(text, start, length)
42‐ UPCASE(text)
43‐ LOWCASE(text)
44‐ TRIMSPC(text, option)
45‐ JUSTIFY(text, direction, fill, length)
46‐ WRNUM(language, numer, part)
47‐ IF(expression, value1, value2)
USE OF FUNCTIONS
Rapor ve formlarda kullanılan fonksiyonlar ve açıklamaları şunlardır:
1.MIN(number, number): Returns the smallest number in the parenthesis.
MIN(5, 6) = 5
2.MAX(number, number): Returns the largest number in the parenthesis.
MAX(5, 6) = 6
3-MOD(number, divisor): Divides the specified number by the divisor, and returns the remainder.
...
MOD(42, 7) = 0
4-DIV(number, divisor): Divides the first number by the second, and returns the result.
...
DIV(42, 7) = 6
5-ABS(number): Takes the absolute value of a number.
ABS(7) = 7
ABS(‐7) = 7
6-VAL(text): Converts the string within the parenthesis into a numeric value.
VAL(“1000”) = 1000
7-DATE(day, month, year): Converts date format according to day, month and year info.
DATE(31, 12, 2000) = 31.12.2000
8-AFTER(days, date): Returns the date after the specified number of days.
...
9-DAYS(firstdate, lastdate): Returns the number of days between two dates.
DAYS(DATE(13,10,2000), DATE(21,10,2000)) = 8
10-DAYOF(date): Returns the day of the date.
DAYOF(DATE(10,12,2000)) = 10
11-MONTHOF(date): Returns the month of the date.
MONTHOF(DATE(10,12,2000)) = 12
12-YEAROF(date): Returns the year of the date.
YEAROF (DATE(10,12,2000)) = 2000
13-WDAYOF(date): Returns the day of the month on which the specified date falls on.
WDAYOF (DATE(30,03,2001)) = 5
14-ROUND(number): Rounds the specified number to the nearest integer.
...
ROUND(5.61) = 6
15-TRUNC(number): Removes decimals of a number and rounds the number to an integer.
...
TRUNC(26.85) = 26
16-ERATE(date, currency): Brings the f. currency exchange rate for a specific date.
...
17-CREATE(date, base curr., base rate, dest curr): Returns the exchange rate equivalent of an amount (in f. currency) in another currency.
...
18-STRPOS(search string, string): Returns the position of the first occurrence of a string inside another string.
STRPOS(“E”,”KALEM”) = 4
19-FLOOR(number): Rounds the specified number to the nearest and smallest integer.
...
FLOOR(‐2,8) = ‐3
20-CEIL(number): Rounds the decimal portion of a number to 1, and converts to an integer.
...
CEIL(15.75) = 16
21-FRAC(number): Omits the integer portion of a number, and then rounds the decimal portion to
...
FRAC(‐3,75) = ‐1
22-EXP(number): It is the opposite of natural logarithm(ln) function. This function calculates the base value (e) of the natural logarithm function raised to the power of X value, and returns after rounding to the nearest integer. EXP(1) = 3 (approximate value of "e")
EXP(2) = 7
23-LN(number): Natural logarithm function. Converts the result of the logarithm function to the
...
EXP (LN (5)) = 5
24-POWER(base, exponent): Shows the specified power of a number.
...
POWER(2,3) = 8 (23)
25-SQR(number): Shows the square (multiplication by itself) of a number.
...
SQR(7) = 49
26-SQRT(number): Shows the square root of a number.
...
SQRT(225) = 15
27-COS(number): Indicates the cosine of a number (an angle given as radiant).
COS(0) = 1
28-SIN(number): Indicates the sine of a number (an angle given as radiant).
29-TAN(number): Indicates the tangent of a number (an angle given as radiant).
30-STRLEN(text): Displays the number of characters of the selected text. The field type is
...
31-WEEKNUM(year start, first week, date): Returns information on the week of year which the specified date falls on. First week parameter works as in MS Outlook.
...
WEEKNUM (DATE(01,01,2002),1, Delivery Date)
32-STR(text): Writes a numeric field in text format.
STR(1234) = 1234
33-DATESTR(date, format): Converts the specified date into text and writes in the required format.
...
DATESTR(DATE(23,12,2001),2) = 23.12.2001
34-MONTHSTR(month): Writes the month corresponding to the number given.
...
MONTHSTR(12) = December
35-WDAYSTR(weekday): Writes the week day corresponding to the number given.
...
36-NUMSTR(number, decimals, format): Converts the specified number into text, and writes in the required format.
...
NUMSTR(‐1234,1,1) = 1.234,0 (A)
37-TIMESTR(time, format): Converts the specified hour into text and writes in the required format.
38-RESXSTR(list source, tag): Brings the relevant string numbered with the specified resource and tag numbers in files with LRF extension under Resource folder. RESXSTR(25550,1) = Stock Code
...
39-RESSTR(string resource): Brings texts within the files with LRF extension under Resource folder.
...
41-SUBSTR(text, start, length): Used to write the selected text in a definite length by starting from a definite character.
SUBSTR(“abcdef”,2,3) = bcd
SUBSTR(“abcdef”,1,4) = abcd
42-UPCASE(text): Writes the text in capital letters
UPCASE(“Text”) = TEXT
43-LOWCASE(text): Writes the text in lowercase.
LOWCASE(“Text”) = text
44-TRIMSPC(text, option): Removes spaces from the beginning and/or the end of the selected text.
...
45-JUSTIFY(text, direction, fill, length): Writes the specified text in the required length. Fills spaces in the text with the
...
46-WRNUM(language, number, part): Converts the integer or decimal portion of a number into text format in the specified language. Numbers corresponding to the languages are defined in Goldset.sys, ERPset.sys files.
...
47-IF(expression, value1, value2): Returns the first value (value1) if the specified condition (expression) is fulfilled. Returns the second value (value2) if it is not. The field type is numeric.
...