Arithmetic operations Updated 3 days ago by Nandini

There are six arithmetic operators you can use in Kissflow: addition (+), subtraction (-), multiplication (*), division (/), and exponents (^).

Field types

It’s important to know what types of fields you are evaluating in an arithmetic expression, or else you may get an error message. You can use number, currency, date, and datetime fields in expressions, along with integers.

Syntax

Arithmetic expressions are written like this:

Number_field1+Number_field2

Evaluating fields

Here are all the ways that you can evaluate fields:

 Field 1 Field 2 Operator Resulting field Number Number +, -, *, / Number Number Integer +, -, *, /, ^ Number Currency1 Currency +, - Currency Currency Number/Integer *, / Currency Date Number/Integer +, - Date Date Date - Number2 Datetime3 Number/Integer +, - Datetime Datetime Datetime - Number Number Datetime + Datetime

1. When combining two currency fields, they must be the same currency

2. If date_1 is 9/21/2020, and date_2 is 9/15/2020, then date_1-date_2 = 6

3. Whole numbers represent 24 hours in datetime fields. If you want to subtract 12 hours, enter datetime_1-0.5