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

Notes:

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


How did we do?