Supported Formulas in Task Schedule

6.0

/

Parameter

User global parameters:

${fine_username}

${fine_position}

${fine_role}

${fr_username}

${fr_userposition}

${fr_authority}

These parameters cannot be used 

during the process of setting a 

scheduled task.

User global parameters can be 

used when SQL datasets are 

added.

Common function

SUM, COUNT, AVERAGE,   CHAR, DATE, MAX, MIN, TIME, RANGE

Email Notification—Subject and Content

Client Notification—Subject and Content

You should not add ${} in Formula Judgment in 

Scheduling Cycle—

Conditions. But you can add ${} in other cases.

For example, 

AND(1+7=8,5+7=12) should 

be written as 

${AND(1+7=8,5+7=12)} in scheduled tasks, and an equal sign (=) should not be added before 

the formula.

Math and 

Trigonometry  function

ABS, ACOS, ACOSH,   ASIN, ASINH, ATAN, ATAN2, AVERAGE, CEILING, COMBIN, COS, SOSH, COUNT,   DECIMAL, DEGREES, EVEN, EXP, FACT, FLOOR, INT, LN, LOG, LOG10, MAX, MIN, MOS,   ODD, PI, POWER, PRODUCT, PROMOTION, RADIANS, RAND, RANDBETWEEN, ROUND,   ROUND5, ROUNDDOWN, ROUNDUP, SIGN, SIN, SINH, SQRT, SUM, SUMPRECISE, SUMSQ,   TAN, TANH, TOBINARY, TOHEX, TOOCTAL, TRUNC, WEIGHTEDAVERAGE

Text function

CHAR, CNMONEY, CODE,   CONCATENATE, ENDWITH, ENMONEY, ENNUMBER, EXACT, FIND, FORMAT, INDEXOF, LEFT,   LEN, LOWER, MIN, NUMTO, PROPER, REGEXP, REPEAT, REPLACE, RIGHT, SPLIT,   STARTWITH, SUBSTITUTE, TODOUBLE, TOINTEGER, TRIM, UPPER

Date and Time   function

DATE, DATEDELTA,   DATEDIF, DATEINMONTH, DATEINQUARTER, DATEINWEEK, DATEINYEAR, DATESUBDATE,   DATETONUMBER, DAY, DAYS360, DAYSOFMONTH, DAYSOFQUARTER, DAYSOFYEAR, DAYVALUE,   ENDOFMONTH, HOUR, ISWORKDAY, LUNAR, MINUTE, MONTH, MONTHDELTA, NOW, SECOND,   TIME, TODATE, TODAY, WEEK, WEEKDATE, WEEKDAY, YEAR, YEARDELTA

Logical function

AND, BITNOT,   BITOPERATION, IF, OR, REVERSE, SWITCH

Report function

COL, DECODE, ENCODE,   I18N, ROW, COLCOUNT, COLNAME, FIELDS, MAP, RECORDS, ROWCOUNT, SQL,   TABLEDATAFIELDS, TABLEDATAS, TABLES, VALUE

Email Notification—Subject and Content

Client Notification—Subject and Content

1. COL and ROW are written 

in cells, although there is no error in Task Schedule, but it is meaningless, and the return value is a constant 0.

COL() can be used to return 

the column number of the 

current cell. For example, if the current cell is A5, writing =COL() in A5 will return 1. 

If the current cell is C6, writing =COL() in A5 will return 3.

2. The parameters of functions (COLCOUNT, COLNAME, 

MAP, ROWCOUNT, TABLEDATAFIELDS, and VALUE)   include datasets. 

Server datasets can be 

obtained in Task Schedule.

Other function

WEBIMAGE, CLASS,   CORREL, EVAL, INDEX, ISNULL, LET, MEDIAN, NVL, QUERY, RANK, SEQ, UUID, LUNAR

Email Notification—Subject and Content

Client Notification—Subject and Content

1. Although SEQ is executed, 

it only happens once, so the 

value remains 1 all the time, 

which has no meaning.

2. WEBIMAGE is used to 

display images on web pages, 

and returns a format similar to   com.fr.file.WebImage@23dd10da in Task Schedule.

Custom function

UBM, SUBSECTION

Email Notification—Subject and Content

Client Notification—Subject and Content

The function of getting cell 

values cannot be used 

in FineBI.