NAME

Arithmetic Op is used to do mathematical operation, such as addition(+), subtraction(-), multiplication(x), division (/) and modulo operation(%) on two elements.

SYNOPSYS

Arithmetic Op needs next parameters or options.

Parameter

 Left Val

• Left operand for binary operation

• Array variable with index is available.

  (ex) 

  {{group.array(1)}}

Operator

•  Binary operation, one of +(add),-(subtract),*(multiply),/(divide),%(modular)

Right Val

• Right operand for binary operation
• Date or DateTime
• Array variable with index is available.
  (ex) 

  {{group.array(2)}}

Value Type

• Set Value type, one of auto, int, float, date, and datetime. 
• Default is 'auto' which means try to guess the best type of value.

 Options

Date Format

• Set the format of Date

  Format	Example
  YYYYMMDD	20190711
  YYYY-MM-DD	2019-07-11
  YYYY/MM/DD	2019/07/11
  MMDDYYYY	07/11/2019
  MM-DD-YYYY	07-11-2019
  MM/DD/YYYY	07/11/2019
  M/D/YYYY	7/8/2019 , 7/11/2019

• 'MM/DD/YYYY', 'M/D/YYYY' are not available on operand. They can be as 'output format' only.

DateTime Format

• Set the format of DateTime

  Format	Example
  YYYYMMDD-HHMMSS	20190711-123322
  YYYY-MM-DD HH:MM:SS	2019-07-11 12:33:22
  YYYY/MM/DD HH:MM:SS	2019/07/11 12:33:22
  MMDDYYYY-HHMMSS	07/11/2019-123322
  MM-DD-YYYY HH:MM:SS	07-11-2019 12:33:22
  MM/DD/YYYY HH:MM:SS	07/11/2019 12:33:22
  M/D/YYYY HH:MM:SS	7/8/2019 12:33:22, 7/11/2019 12:33:22

• 'MM/DD/YYYY', 'M/D/YYYY' are not available on operand. They can be as 'output format' only.

EXAMPLES

Ex1. Calc on numeric values

Parameters

Ex2. Calc on string values

Parameters

Ex3. Calc on Date values

Parameters

Ex4. Calc on DateTime values

Parameters

PLATFORM

Here is the supported platform for this plugin.

• This plugin support Windows 10 and above.
• This plugin support Linux (Ubuntu).
• This plugin support Mac.

Version

• 1.722.1800

Limitation

•  Division (/)& Modular (%) operation does not supported on String value.

SEE ALSO

LICENSE