Ir al contenido principal

How to get the sum of Mask column in Sage ERP X3

ORIGEN FUENTE: https://www.greytrix.com/blogs/sagex3/2015/04/30/how-to-get-the-sum-of-mask-column-in-sage-x3/

You may come across a situation, where you may want to get the sum of Mask column in Sage ERP X3.
Sage ERP X3 has a special function to get the sum of Mask column.
Sigma: This function is used to get sum of Mask column.
Syntax: sigma( [ variable = ] indice_start, indice_end, expression )
Parameter details:
       Variable: Name of the loop variable.
indice_start: Numerical expression stating the start of the range over which the variable may vary.
indice_end: Numerical expression stating the end of the range over which the variable may vary.
           Expression: Numerical or alphanumerical expression.
Kindly refer to the below snippet of code for better understanding.
img1
img2