You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 2 Next »

<ac:structured-macro ac:name="anchor" ac:schema-version="1" ac:macro-id="941776e9-55ad-4c72-8f76-04a843a1adf7"><ac:parameter ac:name="">page1</ac:parameter></ac:structured-macro>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)
<ac:structured-macro ac:name="anchor" ac:schema-version="1" ac:macro-id="392d81e5-379c-4143-9560-939e0a2a1e41"><ac:parameter ac:name="">page2</ac:parameter></ac:structured-macro>
USE OF FUNCTIONS
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(35, 6) = 5
MOD(42, 7) = 0
4. DIV(number, divisor)
Divides the first number by the second, and returns the result.
DIV(35,6) = 5
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.
AFTER(10, DATE(10,02,2001)) = 20.02.2001
AFTER(10, [Current Date]) = 15.02.2001 (If Current date is 05.02.2001)
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
<ac:structured-macro ac:name="anchor" ac:schema-version="1" ac:macro-id="7eeb0baa-c8cd-47d3-8ff9-a93bb8312ab6"><ac:parameter ac:name="">page3</ac:parameter></ac:structured-macro>
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.25) = 5
ROUND(5.61) = 6
15. TRUNC(number)
Removes decimals of a number and rounds the number to an integer.
TRUNC(5.25) = 5
TRUNC(26.85) = 26
16. ERATE(date, currency)
Brings the f. currency exchange rate for a specific date.
ERATE(DATE(05,05,2002),20)
Brings EURO exchange rate entered on May 5, 2002. (Bring the exchange rate of the relevant currency type that is selected for automatic use in F. Currency Usage Parameters.)
17. CREATE(date, base curr., base rate, dest curr)
Returns the exchange rate equivalent of an amount (in f. currency) in another currency.
CREATE(DATE(05,05,2002),1,1500,20) = 1.453,25
Let's assume that USD exchange rate is 1.600.000 TRY and EURO exchange rate is 1.550.000 TRY on May 5, 2002. In order to calculate the equivalent of 1500 EURO in USD on this date, CREATE function is used as shown above, and the functions returns 1.453,25 value as a result. (Mathematical Formula: 1.500*1.550.000/1.600.000)
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) = 2
FLOOR(‐2,8) = ‐3
20. CEIL(number)
Rounds the decimal portion of a number to 1, and converts to an integer.
CEIL(15.25) = 16
CEIL(15.75) = 16
21. FRAC(number)
Omits the integer portion of a number, and then rounds the decimal portion to
the nearest value between 0 and +/‐1.
FRAC(3,15) = 0
FRAC(‐3,15) = 0
FRAC(3,75) = 1
<ac:structured-macro ac:name="anchor" ac:schema-version="1" ac:macro-id="f019a3cf-dafc-4451-8552-a71f5fefcd4f"><ac:parameter ac:name="">page4</ac:parameter></ac:structured-macro>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
nearest integer according to base "e".
LN(2) = 1
EXP (LN (5)) = 5
24. POWER(base, exponent)
Shows the specified power of a number.
POWER(9,2) = 81 (92)
POWER(2,3) = 8 (23)
25. SQR(number)
Shows the square (multiplication by itself) of a number.
SQR(2) = 4
SQR(7) = 49
26. SQRT(number)
Shows the square root of a number.
SQRT(81) = 9
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
numeric.
STRLEN("abcdefg") = 7
STRLEN("999") = 3
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.

  1. The first week of year begins on January 1st.
  2. The first 4‐day week is the first week of year. (If January 1st falls on Friday, the first week of year begins on 4th of January.
  3. The first full week is the first week of year.


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),1) = 12.23.2001
DATESTR(DATE(23,12,2001),2) = 23.12.2001
34. MONTHSTR(month)
Writes the month corresponding to the number given.
MONTHSTR(2) = February
MONTHSTR(12) = December
35. WDAYSTR(weekday)
Writes the week day corresponding to the number given.
WDAYSTR(3) = Wednesday
WDAYSTR(5) = Friday
36. NUMSTR(number, decimals, format)
Converts the specified number into text, and writes in the required format.
NUMSTR(1234,3,1) = 1234
NUMSTR(1234,3,6) = 1234,000 %
NUMSTR(1234,2,7) = 1.234,00
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
RESXSTR(25550,2) = Stock Description
39. RESSTR(string resource)
Brings texts within the files with LRF extension under Resource folder.
RESSTR(29057) = No record is found.

  1. CRESSTR(list id., tag)


  1. 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.
TRIMSPC(" ABC ",1) = ABC
TRIMSPC(" ABC ",2) = ABC
TRIMSPC(" ABC ",3) = ABC
45. JUSTIFY(text, direction, fill, length)
Writes the specified text in the required length. Fills spaces in the text with the
required character.
JUSTIFY(STR(4),1,"0",3) = 004
JUSTIFY("ABC",2,"F",7) = FFABCFF
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.
(1=Turkish, 2=English, 4=German...) In order to write the integer portion in the required language, part is specified as 1. In order to write the decimal portion, part is specified as 2.
WRNUM(1,100,1) = Yuz
WRNUM(2,1000,1) = OneThousand
WRNUM(1,100.05,2) = Bes
WRNUM(4,100.05,1) = Ein(s)Hundert
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.
IF(2*2=4, "Two and two is four", 1500) = Two and two is four IF(2*2=100, "Two and two is four", 1500) = 1500