Summing the Lines(@LineSum)

 

It is function to calculate the sum value of horizontal cells of which vertical cell is variable, such as AI Multi Ave, AI Multi Sum, ...AI Alarm, AI Period Data, DI Multi On Time,... DI ON/OFF List etc. (Data Object for Multiple Lines)

If you select the 'Insert | Function' after selecting the cell (one or several), Insert Function dialogue box comes up.

After inserting the ¡®@LineSum(A:C)¡¯ at Insert Function dialogue box, you can modify this function by using the Cell Text Edit dialogue box. This dialogue box comes up by selecting the 'Form | Cell | Cell Text' or icon of Reporter ToolBox.

Also, you can insert this function by using the Cell Text Edit dialogue box, without Insert Function dialogue box.

 

Function of sum value for lines uses following format. 

-Function definition : double LineSum(cell 1 : cell 2)

-Function parameter : Specific cell number for sum. (start/ end location)

-Result : Sum the calculated multiple lines.

 

@LineSum function uses in case of summing the first cell with second cell horizontally, as same method with @LineAve function.

 

Example of written function)  =@LineSum(D:F);

Function description : It displays all sum values which are multiple lines object (D cell + E cell + F cell) at multiple lines which you specify.

 

 

Relate items)

Data Object for Multiple Lines

Inserting a Function

Reporter ToolBox

Edit a Cell Text

Average Value of Lines(@LineAve)

Insert menu in Reporter Editor

Reporter Editor Main Help