|
FUNCTION USAGE
- MIN(number, number)
Takes the minimum parameter/constant into the parenthesis
MIN(5, 6) = 5
2. MAX(number, number)
Takes the maximum parameter/constant into the parenthesis
MAX(5, 6) = 6
3. MOD(number, divisor)
Divides the higher valued parameter/constant into the lower valued one and takes the remainder
MOD(35, 6) = 5
MOD(42, 7) = 0
4. DIV(number, divisor)
Divides the first parameter/constant to the second and writes the result
DIV(35,6) = 5
DIV(42, 7) = 6
5. ABS(number)
Takes the absolute value of the parameter/constant
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)
Gives the attained date after given 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)
Gives number of days between two dates
DAYS(DATE(13,10,2000), DATE(21,10,2000)) = 8
10. DAYOF(date)
Gives date of the day
DAYOF(DATE(10,12,2000)) = 10
11. MONTHOF(date)
Gives the current month
MONTHOF(DATE(10,12,2000)) = 12
12. YEAROF(date)
Gives the current year
YEAROF (DATE(10,12,2000)) = 2000
13. WDAYOF(date)
Gives the date that shows which day of the week is the given date
WDAYOF (DATE(30,03,2001)) = 5
14. ROUND(number)
Rounds the parameter/constant upwards if its decimal point is bigger than 0,5 and downwards if not.
ROUND(5.25) = 5
ROUND(5.61) = 6
15. TRUNC(number)
Eliminates the decimal characters if the parameter/constant within parenthesis is decimal
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)
It brings Euro currency exchange rate valid on 05.05.2002. (Currency type selected for automatic usage in F. Currency Usage Parameters is considered.)
17. CREATE(date, base curr., base rate, dest curr)
Multiplies the amount in f. currency with cross rate
CREATE(DATE(05,05,2002),1,1500,20) = 1.453,25
Let’s assume that USD exchange rate is 1.600.00 TRY and EURO exchange rate is 1.550.000 TRY on 05.05.2002. In order to find exchange rate value of 1500 EURO on this dat, CREATE function is used as above, and function results in 1.453,25. (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 decimal parameter/constant downwards
FLOOR(2,8) = 2
FLOOR(-2,8) = -3
20. CEIL(number)
Rounds the decimal parameter/constant upwards
CEIL(15.25) = 16
CEIL(15.75) = 16
21. FRAC(number)
Takes the decimal value of the parameter/constant
FRAC(3,15) = 0
FRAC(-3,15) = 0
FRAC(3,75) = 1
FRAC(-3,75) = -1
22. EXP(number)
It is the opposite of natural logarithm (LN) function. Returns the value of e (the base of natural logarithms) raised to the power of X. The inverse of this function is LOG using a single argument only) or LN().
EXP(1) = 3 (approximate value of “e”)
EXP(2) = 7
23. LN(number)
It is logarithm function. According to “e” base it transforms logarithm function result to the nearest integer
LN(2) = 1
EXP (LN (5)) = 5
24. POWER(base, exponent)
Gives specified power of a number.
POWER(9,2) = 81 (92)
POWER(2,3) = 8 (23)
25. SQR(number)
Gives the square of a number
SQR(2) = 4
SQR(7) = 49
26. SQRT(number)
Gives the square root of a number
SQRT(81) = 9
SQRT(225) = 15
27. COS(number)
Gives the cosine of a number (given as radiant
COS(0) = 1
28. SIN(number)
Gives sine of a number(given as radiant),
29. TAN(number)
Gives tangent of a number (given as radiant)
30. STRLEN(text)
Gives the total number of characters of selected text; its type is number
STRLEN(“abcdefg”) = 7
STRLEN(“999”) = 3
31. WEEKNUM(year start, first week, date)
Gives the week number of the related year
First week parameter runs as in MS Outlook.
1: The first week of the year starts with January 1st.
2: The first four-day week is the first week of the year (If January 1st falls on Friday, the first week of the year starts on the 4th day of the month.)
3: The first complete week of the years is considered as the first week of the year.
WEEKNUM (DATE(01,01,2002),1, Delivery date)
32. STR(text)
Writes field defined as numbers in text format
STR(1234) = 1234
33. DATESTR(date, format)
Transforms the given date and writes it in demanded 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 of the given number as text
MONTHSTR(2) = Şubat
MONTHSTR(12) = Aralık
35. WDAYSTR(weekday)
Writes the day of the given number as text
WDAYSTR(3) = Çarşamba
WDAYSTR(5) = Cuma
36. NUMSTR(number, decimals, format)
Transforms the given number to text and writes in demanded form
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)
Transforms the given hour to text and writes in demanded form
38. RESXSTR(list source, tag)
Brings the string corresponding to the related tag and list source at the LRF extended files of resource
RESXSTR(25550,1) = Stock code
RESXSTR(25550,2) = Stock description
39. RESSTR(string resource)
Brings the texts in LRF extended files of resource folder
RESSTR(29057) = Legitimate record could not be found.
40. CRESSTR(list id., tag)
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 with capital letters
UPCASE(“Text”) = TEXT
43. LOWCASE(text)
Writes the text with lower cases
LOWCASE(“Text”) = text
44. TRIMSPC(text, option)
Deletes the spaces at the beginning and/or at 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 selected text in demanded length. Fills the spaces with demanded characters in text
JUSTIFY(STR(4),1,“0”,3) = 004
JUSTIFY(“ABC”,2,“F”,7) = FFABCFF
46. WRNUM(language, number, part)
Transforms a number’s integer or decimal digits to writing form in 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 integer in the required language, part is given value 1. If decimal digits are required to be written, part is given value 2.
WRNUM(1,100,1) = Yüz
WRNUM(2,1000,1) = OneThousand
WRNUM(1,100.05,2) = Beş
WRNUM(4,100.05,1) = Ein(s)Hundert
47. IF(expression, value1, value2)
Specifies values by defining conditions.
If the specified expression is provided, the first value (value1) returns. It is not provided, the second value (value2) returns. Its type is number.
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
|
