Get to Know FineBI Cloud Get Started as a Viewer Get Started as an Editor Start Your First Analysis Manage Account Settings

Connect Your Data

Upload Excel Data

Troubleshoot Excel Data Sources

Synchronize Data Manage Data Source Permissions

Connect Local Data Sources

Analyze and Visualize Data

Manage Spaces and Projects

Analyze Data Create Charts Use Calculation Models Drill Down into Charts Optimize Performance Use Example Cases

CHAR CONCATENATE RIGHT LEFT REPEAT REPLACE MID TRIM TONUMBER

INT LOG MOD ROUND ROUNDDOWN ROUNDUP SQRT ABS CEILING MAX MIN

Date and Time Functions

DATEIF DATESUBDATE YEAR DAY MONTH HOUR MINUTE SECOND

Aggregate Functions

SUM AVERAGE COUNT COUNTD MIN MAX MEDIAN VAR.P STDEV.P PERCENTILE.INC

Other Functions

Add Analysis Steps

Use Row-Based Calculations

Window Calculation

Create Advanced Tables

Use Nines AI Analyst

Meet Nines View AI Credit Usage

Build Dashboards

Create a Dashboard Create a Storyboard Publish Content

Add Interactions

Drill Down in Dashboards

Use FineBI Next on Mobile

Manage Notifications

FAQs Account Closure Agreement

Template Gallery

Use Templates Publish Templates Troubleshoot Template Publishing

Get Started as an Admin

Create Businesses

Integrate with Lark

Send Lark Cards

Configure User Groups Enable/Disable Members Configure User Properties

Manage Permissions

Manage Business

Business Information

Manage Business Settings

Enable Global Watermark

Manage SSO Settings

Configure Single Sign-On Integrate Apps

Customize the Login Page Configure Business Style Set the System Language Set the System Time Zone

Enable Webhook (Message)View Audit Logs

Analytics · Reporting · Data Agents

Try FineBI Free

Products

Cloud

Solutions

Business Analysis
Supply Chain
Marketing
Manufacturing
Transportation & Logistics
Finance

Resources

Certification
Customer Stories
Documentation

About Us

Who we are
Support and Service
Global Office/Contact
Partners

© 2026, FanRuan Software Co., Ltd. All Rights Reserved.

Analyze and Visualize DataUse FunctionsOther Functions

Other Functions

How is this documentation?

PreviousPERCENTILE.INC NextISNULL