Math Functions

This article lists all math functions in YiDA, along with their common use cases.

Function Overview

Function name	Description
COUNT	Counts the total number of data records submitted for a specified form.
ADD	Calculates the sum of multiple field values.
AVERAGE	Returns the arithmetic mean of a set of Numerical values.
MAX	Returns the maximum value in a set of numbers.
MIN	Returns the minimum value in a set of numbers.
ABS	Returns the absolute value of a number when it is negative.
ROUND	Rounds a number to the specified number of decimal places.
CEILING	Rounds the parameter number up (away from zero) to the nearest multiple of the specified base.
FLOOR	Rounds the parameter number down (toward zero) to the nearest multiple of significance.
INT	Rounds a number down to the nearest integer.
LOG	Returns the logarithm of a number to the specified base.
MOD	Returns the remainder from dividing two Numerical components.
POWER	Calculates the result of a Numerical component raised to a power.
FIXED	Rounds a number to the specified number of decimal places, formats it in decimal notation, and returns the result as a number.
SQRT	Returns the positive square root of a Numerical component value.
SUM	Adds all numbers passed as parameters and returns their sum.
PRODUCT	Returns a result of the double-precision float type.
SUMPRODUCT	Multiplies corresponding elements in the given arrays and returns the sum of those products.
LARGE	Returns the k-th largest value in a data set.
SMALL	Returns the k-th smallest value in a data set.

Common Scenarios

Calculate the Total Amount Across Multiple Line Items

In a purchase reimbursement scenario, multiple categories are often reimbursed together. To calculate the total amount across all line items, follow these steps:

(1) Add a subform component to the form (configured with unit price, quantity, and amount), and Add a Numerical or Single-line text component outside the subform. (2) In the amount component inside the subform, configure Subform.Unit price * Subform.Quantity. Then, in the Numerical or Single-line text component outside the subform, configure SUM(Subform.Amount). The result is shown in the animation below.

Getting Started

Quick Start

Form Management

Workflow Design

Report Design

Aggregate Table Design

Portal Design

Custom Pages

Integration & Automation

Cool App

App Management

Platform Management

Internationalization

YiDA Dedicated

Developer Features

Function Overview

Common Scenarios

Calculate the Total Amount Across Multiple Line Items

​Function Overview

​Common Scenarios

​Calculate the Total Amount Across Multiple Line Items

Function Overview

Common Scenarios

Calculate the Total Amount Across Multiple Line Items