FineBI version
5.0
This article will introduce in detail the formulas and their usages that can be used in the process of setting timed scheduling tasks.
Note: When the object type in the "Scheduling Object" step is a report template and no scheduling object, the formula and usage that can be used can be referred to Formulas supported by timing scheduling
Note: The functions shown in the following table cannot be used to get cell values, that is, cell values cannot be used as parameters in BI templates.
type
formula/parameter/function
utilized location
Remark
parameter
User global parameters:
${ fine_username }
${ fine_position }
${ fine_role }
${ fr_username }
${ fr_userposition }
${ fr_authority }
It cannot be used during the timed scheduling task setting process
User global parameters can be used when adding SQL datasets
Common functions
SUM, COUNT, AVERAGE, CHAR, DATE, MAX, MIN, TIME, RANGE
dispatch object - file name
Scheduling Period - Execution Conditions - Formula Judgment
File Handling - Email Notification - Subject and Content
File Handling - Client Notification - Subject and Content
Do not add ${} in "Scheduling Period - Execution Condition - Formula Judgment", and 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 timing scheduling , do not add = sign
Math and Trigonometry
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, RANDB ETWEEN, 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 functions
DATE, DATEDELTA, DATEDIF, DATEINMONTH, DATEINQUARTER, DATEINWEEK, DATEINYEAR, DATESUBDATE, DATETONUMBER, DAY, DAYS360, DAYSOFMONTH, DAYSOFQUARTER, DAYSOFYEAR, DAYVALUE, HOUR, LUNAR, MINUTE, MONTH, MONTHDELTA, NOW, SECOND, TIME, TODATE, TODAY, WEEK, WEEKDATE, WEEKDAY, YEAR, YEARDELTA
Logical function
AND, BITNOT, BITOPERATION, IF, OR, REVERSE, SWITCH
array function
ADD2ARRAY, ARRAY, GREPARRAY, INARRAY, INDEXOFARRAY, JOINARRAY, MAPARRAY, RANGE, REMOVEARRAY, REVERSEARRAY, SLICEARRAY, SORTARRAY, UNIQUEARRAY
report function
COL, DECODE, ENCODE, I18N, ROW, COLCOUNT, COLNAME, FIELDS, MAP, RECORDS, ROWCOUNT, SQL, TABLEDATAFIELDS, TABLEDATAS, TABLES, VALUE
1) COL and ROW are written in the cell, although no error will be reported in timing scheduling, but it is meaningless, and the return value is the constant 0.
COL() returns the column number of the current cell.
For example, if the current cell is A5, write in A5: =col() , return 1; if the current cell is C6, write in A5: =col() , return 3
2) The parameters of COLCOUNT , COLNAME , MAP , ROWCOUNT , TABLEDATAFIELDS , and VALUE include data sets. In timing scheduling, you can get server data sets
other functions
WEBIMAGE, CLASS, CORREL, EVAL, INDEX, ISNULL, LET, MEDIAN, NVL, QUERY, RANK, SEQ, UUID, LUNAR
1) Although SEQ is executed, it is always only once, so the value is always, meaningless
2) WEBIMAGE is used to display pictures on web pages, and returns a format similar to com.fr.file.WebImage@23dd10da in timing scheduling
custom function
UBM, SUBSECTION
The function that takes the cell value cannot be used in FineBI
滑鼠選中內容,快速回饋問題
滑鼠選中存在疑惑的內容,即可快速回饋問題,我們將會跟進處理。
不再提示
10s後關閉
Submitted successfully
Network busy