摘要:OverviewThis document introduces the calculation types you can use in FineBI.You can use the followin[阅读全文:]

摘要:VersionFineBI VersionFunctional Change6.0.16/OverviewThe IFERROR function is used to identify an[阅读全文:]

摘要:OverviewDEF_ADD function calculates the value of the aggregate indicator based on the dimension speci[阅读全文:]

摘要:OverviewThe DEF function calculates the value of the aggregate indicator based on the specified dimen[阅读全文:]

摘要:OverviewGrammarFIND(find_text,within_text,start_num)Returns the first specified substring (find_text)[阅读全文:]

摘要:Extracted DataOverviewGrammarLEN(args)Returns the number of characters of a string.Parameter 1argsPar[阅读全文:]

摘要:OverviewGrammarCONCATENATE(text1,text2,...)Joins at least two strings into one.Parameter 1Text1,text2[阅读全文:]

摘要:Usage 1: Replacing Specified Content of a TextOverviewGrammarREPLACE(text,textorreplace,replacetext)R[阅读全文:]

摘要:OverviewGrammarINDEXOF(str1,index)Returns the character in str1 at the position specified by index.Pa[阅读全文:]

摘要:OverviewGrammarTODOUBLE(text)Converts a text to a Double object (a double-precision floating-point nu[阅读全文:]

摘要:OverviewGrammarRIGHT(text,num_chars)Returns the last or last several characters in the text, based on[阅读全文:]

摘要:OverviewGrammarUPPER(text)Converts all characters in a text to uppercase.Parameter 1TextText to be co[阅读全文:]

摘要:OverviewGrammarSPLIT(String1,String2 )Returns an array of character strings splited from String1 by t[阅读全文:]

摘要:OverviewGrammarREPEAT(text,number_times)Repeats a text a specified number of times.Parameter 1textTex[阅读全文:]

摘要:OverviewGrammarTOINTEGER(text)Converts a text to an Integer object.Parameter 1TextText to be converte[阅读全文:]

摘要:OverviewGrammarEXACT(text1,text2)Determines whether two text strings are identical. If they are exact[阅读全文:]

摘要:OverviewGrammarMID(text,start_num,num_chars)Returns a user-specified number of characters from a spec[阅读全文:]

摘要:OverviewDEF, DEF_ADD, and DEF_SUB functions allow users to modify or control the calculation level of[阅读全文:]

摘要:Extracted DataUsage 1OverviewGrammarREGEXP(str,pattern)Determines whether a character string (specifi[阅读全文:]

摘要:OverviewGrammarNVL(value1,value2,value3,...)Returns the first non-null value among all parameters.Not[阅读全文:]

摘要:OverviewGrammarISNULL(object)Determines whether an object is null or empty.Parameter 1objectObject to[阅读全文:]

摘要:OverviewGrammarSTARTWITH(str1,str2)Determining whether str1 starts with str2.Parameter 1str1Character[阅读全文:]

摘要:OverviewGrammarPROPER(text)Capitalizes the first letter and letters that follow any non-letter charac[阅读全文:]

摘要:OverviewGrammarCODE(text)Returns a numeric code for the first character in a text string. The returne[阅读全文:]

摘要:OverviewGrammarCHAR(number)Returns the character specified by a number, by which you can convert code[阅读全文:]

摘要:OverviewGrammarLOWER(text)Converts all characters in text to lowercase.Parameter 1textText to be conv[阅读全文:]

摘要:Overview GrammarTRIM(text)Returns the text with all leading and trailing spaces removed.Paramete[阅读全文:]

摘要:OverviewGrammarENDWITH(str1, str2)Determines whether str1 ends with str2.Parameter 1str1Character str[阅读全文:]

摘要:OverviewGrammarNUMTO (number, bool) or NUMTO (number)Returns number-converted Chinese texts.Parameter[阅读全文:]

摘要:OverviewGrammarLEFT(text, num_chars)Returns the first or first several characters in the text, based[阅读全文:]

摘要:OverviewGrammarSUBSTITUTE(text, old_text, new_text, instance_num)Substitutes new_text for old_text in[阅读全文:]

摘要:OverviewIn scenarios where frequent format conversion is required during data analysis, FineBI provid[阅读全文:]

摘要:OverviewGrammarTAN(number)Returns the tangent of a given angle.ParameternumberThe angle in radians yo[阅读全文:]

摘要:OverviewGrammarSIGN(number)Calculates the sine of a given angle.ParameternumberThe angle in radians y[阅读全文:]

摘要:OverviewGrammarRADIANS(angle)Converts degrees to radians.ParameterAngleAn angle in degrees to be conv[阅读全文:]

摘要:OverviewGrammarPOWER(number, power)Returns the result of a number raised to a power.Parameter 1number[阅读全文:]

摘要:OverviewGrammarPI(number)Returns the mathematical constant pi.ParameternumberWhen the number is empty[阅读全文:]

摘要:OverviewGrammarDEGREES(angle)Converts radians to degrees.ParameterAngleThe angle in radians to be con[阅读全文:]

摘要:OverviewGrammarCOS(number)Returns the cosine of an angle.ParameternumberThe angle in radians you want[阅读全文:]

摘要:OverviewGrammarATAN2(x_num, y_num)Returns the arctangent of X and Y coordinates. The arctangent is th[阅读全文:]

摘要:OverviewGrammarACOS(number)Returns the arccosine, namely inverse cosine, of a number. The arccosine v[阅读全文:]

摘要:OverviewGrammarACOS(number)Returns the arcsine, or inverse sine, of a number. The arcsine value is an[阅读全文:]

摘要:OverviewGrammarATAN(number)Calculates the arctangent, or inverse tangent, of a number. The parameter[阅读全文:]

摘要:OverviewGrammarEXP(number)Returns the nth power of e. The constant e is based on the natural logarith[阅读全文:]

摘要:Extracted Data VersionOverviewGrammarMOD(number, divisor)Returns the remainder after the number is di[阅读全文:]

摘要:OverviewGrammarPROMOTION(value1, value2)Returns the proportion increased from value1 to value2.Parame[阅读全文:]

摘要:Extracted Data VersionOverviewGrammarCEILING(number)Rounds up the number parameter to the nearest int[阅读全文:]

摘要:OverviewGrammarSQRT(number)Returns the arithmetic square root of a non-negative number. You can set n[阅读全文:]

摘要:Extracted Data VersionOverviewGrammarFLOOR(number)Rounds down the number parameter to the nearest int[阅读全文:]

摘要:OverviewGrammarMIN(number 1, number 2, ...)Returns the minimum value among listed parameters.Paramete[阅读全文:]

摘要:OverviewGrammarFACT(number)Returns the factorial of a number (equal to N in 1*2*3*...*N).Paramet[阅读全文:]

摘要:OverviewGrammarRANDBETWEEN(value1, value2)Returns a random integer between value1 and value2.When the[阅读全文:]

摘要:OverviewGrammarSIGN(number)Returns the sign of a number. Returns 1 for positive numbers, 0 for zero,[阅读全文:]

摘要:OverviewGrammarLN(number)Returns the natural logarithm of a number. The natural logarithm is based on[阅读全文:]

摘要:OverviewGrammarTRUNC(number, num_digits)Truncates a number to an integer or a decimal by removing spe[阅读全文:]

摘要:OverviewGrammarMAX(number 1, number 2, ...)Returns the maximum value among listed parameters.Par[阅读全文:]

摘要:OverviewEARLIER: Get the value of the current row. It is only applicable to DEF, DEF_ADD, and DEF_SUB[阅读全文:]

摘要:Use ScopeUse LocationDashboardAdding Calculation IndicatorFunction ListFunctionDescriptionPERIOD_ANLS[阅读全文:]

摘要:OverviewSUM_AGG function is used to summarize and add up data for the specified dimension (dragg[阅读全文:]

摘要:OverviewSyntaxLUNAR(year, month, day)Returns the lunar time corresponding to the current datePar[阅读全文:]

摘要:1. OverviewThis article describes how to create and use calculation functions in FineBI using example[阅读全文:]