ÇØ°á |
Abs( n ) |
¼³¸í |
¼öÀÇ Àý´ë°ªÀ» ¾ò´Â´Ù. |
¹®¹ý |
Abs ( n ) n ; Àý´ë°ªÀ» °®±â À§ÇÑ ¼ö |
¿¹ |
Abs(-4.2) ¡æ 4.2 |
Asc( s )
|
¼³¸í |
stringÀÇ Ã¹ ¹®ÀÚ¸¦ Ascii code·Î º¯È¯ÇÑ´Ù. |
¹®¹ý |
Asc( string ) |
¿¹ |
If (Asc(code_id) = 65, code_id, "Not a valid code")
datawindowÀÇ computed fieldÀÇ expression¿¡¼ code_id¾ÈÀÇ Ã¹¹ø° ¹®ÀÚÀÇ
Ascii °ªÀÌ A(65)À̸é code_id¾ÈÀÇ stringÀ» ¹ÝȯÇÑ´Ù. |
Avg( #x for group 1
)
|
¼³¸í |
column°ªÀÇ Æò±ÕÀ» °è»êÇÑ´Ù. |
¹®¹ý |
Avg ( column FOR range DISTINCT Expres1 ,Expres2 ,..)
column : data°ªÀÇ Æò±ÕÀ» ±¸Çϱ⠿øÇÏ´Â columnÀÇ À̸§.pound sign(#)¿¡ ÀÇÇØ
ÁøÇàµÇ´Â columnÀÇ ¼ö³ª columnÀÇ À̸§ÀÌ µÉ¼ö ÀÖ´Ù.¶ÇÇÑ column¿¡ ¾ð±ÞµÈ
expressionÀÌ µÉ ¼ö ÀÖ´Ù.columnÀº data.´ëºÎºÐÀÇ ¹Ýµå½Ã numericÇüÀ̾î¾ß
ÇÑ´Ù.
FOR range : Æò±Õ¿¡ Æ÷Ç﵃ presentationstyle¿¡¼ rangeÀÇ °ªÀº
All(column¾ÈÀÇ ¸ðµçgroup¾ÈÀÇ °ªÀÇ Æò±Õ)
Group n(±â¼úµÈ columnÀÇ Æò±Õ)
Page n(±â¼úµÈ page¾ÈÀÇ columnÀÇ Æò±Õ) ±× ¿Ü¿¡ GROSTAB,GRAPH,OBJECTµîµî.
DISTINCT : column°ª¿¡¼ ù¹ø° ÇàÀÌ °ªÀ» »ç¿ëÇÏ°í ÀÖ´Â °ÍÀÌ ¹ß°ßµÇ¸é °°Àº
°ªÀ» °¡Áø ´Ù¸¥ ÇàÀº ¹«½ÃµÈ´Ù. |
¿¹ |
Avg(order_amt for all DISTINCT order_nbr)
ÀÌ computed feild´Â Áߺ¹µÇ´Â drder number¸¦ »©°í order
amountÀÇ Æò±Õ°ªÀ» ¹Ýȯ.
This expression returns the average of the values in column
5 on the current page.
Avg(#5 for page) |
Bitmap ( s )
|
¼³¸í |
±â¼úµÈ bitmapÀ» displayÇÑ´Ù.( Bitmap functionÀº ´ÜÁö computed field¿¡¼¸¸
»ç¿ë.) |
¹®¹ý |
Bitmap ( s )
S : bitmap fileÀ» Æ÷ÇÔÇÏ´Â column,À̹ÌÁö ÆÄÀÏÀÇ À̸§À»
Æ÷ÇÔÇÏ´Â string.
S°¡ bitmap fileÀ» Æ÷ÇÔÇÏ´Â columnÀÏ ¶§ °¢°¢ÀÇ row¿¡
´Ù¸¥ bitmapÀ» Ç¥½ÃÇÒ ¼ö ÀÖ´Ù. |
¿¹ |
Bitmap(If(password = "y", "yes.bmp", "no.bmp"))
À§ÀÇ expressionÀº password·Î ¸í¸íµÈ columnÀ» Å×½ºÆ®ÇÏ°í
displayÇϱâ À§ÇÑ
bitmapÀ» °áÁ¤Çϱâ À§ÇØ »ç¿ëÇÑ´Ù. |
Ceiling( x )
|
|
|
Case( x when a then
b when c then d...
else e)
|
|
|
Char( x )
|
|
|
Cos( x )
|
|
|
Count( #x for group
1 )
|
|
|
Crosstabavg( 1 )
|
|
|
Crosstabcount( 1 )
|
|
|
Crosstabmax( 1 )
|
|
|
Crosstabmin( 1 )
|
|
|
Crosstabsum( 1 )
|
|
|
CumulativePercent(
#x for group 1 )
|
|
|
CumulativeSum( #x
for group 1 )
|
|
|
CurrentRow() |
|
|
Date( s )
|
|
|
Datetime( s )
|
|
|
Day( d )
|
|
|
Dayname( d )
|
|
|
Daynumber( d )
|
|
|
Daysafter( d, d )
|
|
|
Describe( s )
|
|
|
Exp( x )
|
|
|
Fact( x )
|
|
|
Fill( s, x )
|
|
|
First( #x for group
1 )
|
|
|
Getrow()
|
|
|
Gettext()
|
|
|
Hour( t )
|
|
|
If( b, t, f )
|
|
|
Int( x )
|
|
|
Integer( s )
|
|
|
IsDate( s )
|
|
|
IsNull( x )
|
|
|
IsNumber( s )
|
|
|
IsRowModified()
|
|
|
IsRowNew() |
|
|
IsSelected())
|
|
|
IsTime( s )
|
|
|
Large( #x, #x, n for
group 1
|
|
|
Last( #x for group 1
)
|
|
|
Left( s, n )
|
|
|
LeftTrim( s )
|
|
|
Len( s )
|
|
|
Log( x )
|
|
|
Logten( x )
|
|
|
Long( s )
|
|
|
Lookupdisplay( #x )
|
|
|
Lower( s )
|
|
|
Match( s, s )
|
|
|
Max( #x for group 1
)
|
|
|
Median( #x for group
1 )
|
|
|
Mid( s, start, len )
|
|
|
Minute( t )
|
|
|
Mod( x, y )
|
|
|
Mode( #x for group 1
)
|
|
|
Month( d ) |
|
|
Now()
|
|
|
Number( s )
|
|
|
Page()
|
|
|
PageAcross())
|
|
|
PageCount()
|
|
|
PageCountAcross()
|
|
|
Percent( #x for
group 1)
|
|
|
Pi( x )
|
|
|
Pos( s, s, x )
|
|
|
Profileint( s, s, s,
x)
|
|
|
Profilestring( s, s,
s, s)
|
|
|
Rand( x )
|
|
|
Real( s )
|
|
|
Relativedate( d, x )
|
|
|
Relativetime( t, x )
|
|
|
Replace( s, x, y, s
)
|
|
|
Rgb( r, g, b)
|
|
|
Right( s, n )
|
|
|
RightTrim( s )
|
|
|
Round( x, n ) |
|
|
Rowcount()
|
|
|
Rowheight()
|
|
|
Second( t )
|
|
|
Secondsafter( t, t )
|
|
|
Sign( x )
|
|
|
Sin( x )
|
|
|
Small( #x, #x, n for
group 1 )
|
|
|
Space( x )
|
|
|
Sqrt( x )
|
|
|
Stdev( #x for group
1 )
|
|
|
Stdevp( #x for group
1 )
|
|
|
String( x, s )
|
|
|
Sum( #x for group 1
))
|
|
|
Tan( x )
|
|
|
Time( s )
|
|
|
Truncate( x, y )
|
|
|
Upper( s )
|
|
|
Var( #x for group 1
)
|
|
|
Varp( #x for group 1
) |
|
|
Wordcap( s )
|
|
|
Year( d ) |
|
|
|
|
|
|