Skip to end of metadata
Go to start of metadata


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

Left Val

Op

Right Val

Results

100

+

2

102

100

-

2

98

100

*

2

200

100

/

2

50

100

%

2

0


Ex2. Calc on string values

Parameters

Left Val

Op

Right Val

Results

Hello

+

World

HelloWorld

Hello

-

o

Hell

Hello

x

3

HelloHelloHello

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


Ex3. Calc on Date values

Parameters

Left Val

Op

Right Val

Date Format

Results

20160228

+

1day

M/D/YYYY

2/29/2016

2016-02-28

+

1month

MM/DD/YYYY

2016/03/28

2016/02/28

+

2year

MM-DD-YYYY

02-28-2018

07-10-2019

-

1day

MMDDYYYY

07092019

07102019

-

1month

YYYYMMDD

20190610

07/10/2019

-

2year

YYYY-MM-DD

2017-07-10


Ex4. Calc on DateTime values

Parameters

Left Val

Op

Right Val

DateTime Format

Results

20160228-173023

+

50sec

YYYYMMDD-HHMMSS

20160228-173113

2016-02-28 17:30:23

+

30min

YYYY-MM-DD HH:MM:SS

2016-02-28 18:00:23

2016/02/28 17:30:23

+

2hour

YYYY/MM/DD HH:MM:SS

2016/02/28 19:30:23

07102019-235920

+

20min

MMDDYYYY-HHMMSS

07112019-001920

07-10-2019 00:00:10

-

30min

MMDDYYYY HH:MM:SS

07-09-2019 23:30:10


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