Features
Pricing
Support
News
Contact us
Log in

Log in

Documentation
Templates
Training
Webinars
Consulting

Features

Form designer
Report designer
Integrations
Data entry
All features
New features

Pricing

Support

Documentation
Templates
Training
Webinars
Consulting

News Contact us

Support
Documentation
Formulas
Mathematical Functions

Mathematical Functions

ADD (+)
SUBTRACT (-)
MULTIPLY (*)
DIVIDE (/)
CEIL
FLOOR
POWER

Formulas

Logical Functions

AND (&&)
OR (||)
IF
NOT (!)
EQUAL (==)
NOT EQUAL (!=)
GREATER (>)
GREATER OR EQUAL (>=)
LESS (<)
LESS OR EQUAL (<=)
ISNUMBER
ISBLANK

Text Functions

SEARCH
CONCAT
LEFT
RIGHT
MID
REGEXMATCH
REGEXREPLACE
REGEXEXTRACT

Date & Time Functions

TODAY
DATE
ADDDATE
DAY
MONTH
QUARTER
YEAR
DAYS
YEARFRAC

Statistical Functions

SUM
AVERAGE
MEDIAN
MAX
MIN
COUNT
COUNTDISTINCT

Mathematical Functions

ADD (+)
SUBTRACT (-)
MULTIPLY (*)
DIVIDE (/)
CEIL
FLOOR
POWER

COALESCE

ActivityInfo

About us
News and stories
Careers

Contact us

Resources

Case studies
Documentation
Webinars
API guide
Release notes

Use cases

Monitoring & Evaluation
Humanitarian coordination
Case Management

Server status
Terms of service
Privacy policy

Join our LinkedIn Group or follow ActivityInfo