Sum(Number [,Numbers])<\/strong><\/p>\n Returns the sum of values per timestamp.<\/p>\n Number: <\/b>The argument whose values should be summed. Numbers: <\/b>Additional arguments whose values should be summed. How to format data types<\/a><\/p>\n \u00a0<\/p>\n An error will be thrown if:<\/p>\n Expression: Sum(1,2) Expression: Sum(1,2,1) Expression: Sum({Tag1}, {Tag2}) Tip: If you have access to the sample data, try running the following example using the\u00a0calculation tester<\/a>.\u00a0<\/p>\n Expression:\u00a0Sum({Abes.GasActual},{Anstey.GasActual},{Archer.GasActual})<\/span> The following table illustrates the difference between the Sum<\/strong>(), DDSum<\/a><\/strong>(), and Sum_Sampled<\/a><\/strong>() functions. The following calculations were used to sum a row (Sum_Sampled<\/em>) or column (Sum<\/em> and DDSum<\/em>):<\/p>\n Total Daily Oil Production for all online wells<\/strong>: Total Weekly Oil Production for a well<\/strong>: In this example, Well 3 did not exist before Tuesday, and the Sum() and Sum_Sampled() calculations will throw an error if an entity does not exist.<\/p>\n Notes:<\/strong><\/p>\n *<\/span><\/strong> For Well 3, the Sum_Sampled<\/strong>() calculation should not include Monday<\/em>, because it did not exist then. It will throw an error if you try to evaluate Well 3 starting from Monday, but will return a value if you evaluate it from Tuesday.<\/p>\n **<\/span><\/strong> On Monday, the Sum<\/strong>() calculation should not include Well 3<\/em>, because it did not exist then and will throw an error. Well 3 can only be included in the calculation from Tuesday onwards.<\/p>\n ^<\/strong><\/span> For an explanation of how the values for DDSum<\/a>() and Sum_Sampled<\/a>() are calculated, refer to their respective pages.<\/p>\n <\/p>\n","protected":false},"excerpt":{"rendered":" Returns the sum of values per timestamp.<\/p>\nReturns<\/h2>\n
Inputs<\/h2>\n
\n Behaviour: Required
\n Dimensions: Collection, SingleValue
\n Valid data types: Decimal, Integer<\/p>\n
\n Behaviour: Optional [0..n]
\n Dimensions: Collection, SingleValue
\n Valid data types: Decimal, Integer<\/p>\nError Conditions<\/h2>\n
\n
\n
Examples<\/h2>\n
\n Result: Returns 3.<\/p>\n
\n Result: Returns 4.<\/p>\n
\n Result: Returns the sum of values for each timestamp.<\/p>\n
\n Returns: The total Gas Actual for Abes, Anstey, and Archer.\u00a0
\n Result:\u00a011584<\/p>\nRelated Functions<\/h2>\n
\n DDSum(DDGet(\"Hierarchy\", 2, \"Field1\", \":Oil Production\", \"{[Well]:Status} == 'Online'\", \"Well\"))<\/span>
\n Sum({Well 1:Oil Production},{Well 2:Oil Production})<\/span>
\n Sum({Well 1:Oil Production},{Well 2:Oil Production},{Well 3:Oil Production})<\/span><\/p>\n
\n Sum_Sampled({Well 1:Oil Production},\"Monday\",\"Friday\")
\n Sum_Sampled({Well 2:Oil Production},\"Monday\",\"Friday\")
\n Sum_Sampled({Well 3:Oil Production},\"Tuesday\",\"Friday\")
\n <\/span><\/p>\n\n\n
\n Entity\/Attributes<\/strong><\/td>\n Timestamps<\/strong><\/td>\n \u00a0<\/td>\n \u00a0<\/td>\n<\/tr>\n \n \u00a0<\/td>\n \u00a0<\/td>\n \u00a0<\/td>\n Monday**<\/span><\/strong><\/td>\n Tuesday<\/td>\n Wednesday<\/td>\n Thursday<\/td>\n Friday<\/td>\n Total Weekly Oil Production Using Sum_Sampled<\/a>()^<\/span><\/strong><\/td>\n Calc Used:<\/td>\n<\/tr>\n \n Field 1<\/td>\n Well 1<\/td>\n Production (bbl):<\/td>\n 1<\/strong><\/td>\n 3<\/td>\n 2<\/strong><\/td>\n 4<\/strong><\/td>\n 2<\/strong><\/td>\n 12<\/strong><\/td>\n Sum_Sampled({Well 1:Oil Production},\"Monday\",\"Friday\")<\/span><\/td>\n<\/tr>\n \n \u00a0<\/td>\n Status:<\/td>\n Online<\/strong><\/td>\n Offline<\/td>\n Online<\/strong><\/td>\n Online<\/strong><\/td>\n Online<\/strong><\/td>\n \u00a0<\/td>\n<\/tr>\n \n Well 2<\/td>\n Production (bbl):<\/td>\n 2<\/strong><\/td>\n 1<\/strong><\/td>\n 1<\/td>\n 3<\/strong><\/td>\n 2<\/strong><\/td>\n 9<\/strong><\/td>\n Sum_Sampled({Well 2:Oil Production},\"Monday\",\"Friday\")<\/span><\/td>\n<\/tr>\n \n \u00a0<\/td>\n Status:<\/td>\n Online<\/strong><\/td>\n Online<\/strong><\/td>\n Offline<\/td>\n Online<\/strong><\/td>\n Online<\/strong><\/td>\n \u00a0<\/td>\n<\/tr>\n \n Well 3*<\/span><\/strong><\/td>\n Production (bbl):<\/td>\n DID NOT EXIST<\/strong><\/span><\/td>\n 2<\/strong><\/td>\n 1<\/strong><\/td>\n 2<\/td>\n 2<\/strong><\/td>\n 7*<\/span><\/strong><\/td>\n Sum_Sampled({Well 3:Oil Production},\"Tuesday\",\"Friday\")<\/span><\/td>\n<\/tr>\n \n \u00a0<\/td>\n Status:<\/td>\n Online<\/strong><\/td>\n Online<\/strong><\/td>\n Offline<\/td>\n Online<\/strong><\/td>\n \u00a0<\/td>\n<\/tr>\n \n Total Daily Oil Production Using Sum<\/a>()<\/strong><\/td>\n \u00a0<\/td>\n \u00a0<\/td>\n 3**<\/span><\/strong><\/td>\n 6<\/b><\/span><\/td>\n 4<\/strong><\/td>\n 9<\/b><\/span><\/td>\n 6<\/strong><\/td>\n \u00a0<\/td>\n \u00a0<\/td>\n<\/tr>\n \n \u00a0<\/td>\n \u00a0<\/td>\n \u00a0<\/td>\n Sum({Well 1:Oil Production},{Well 2:Oil Production})<\/span><\/td>\n Sum({Well 1:Oil Production},{Well 2:Oil Production},{Well 3:Oil Production})<\/span><\/td>\n Sum({Well 1:Oil Production},{Well 2:Oil Production},{Well 3:Oil Production})<\/span><\/td>\n Sum({Well 1:Oil Production},{Well 2:Oil Production},{Well 3:Oil Production})<\/span><\/td>\n Sum({Well 1:Oil Production},{Well 2:Oil Production},{Well 3:Oil Production})<\/span><\/td>\n \u00a0<\/td>\n \u00a0<\/td>\n<\/tr>\n \n Total Daily Oil Production Using DDSum<\/a>()^<\/span><\/strong>
\n DDSum(DDGet(\"Hierarchy\", 2, \"Field1\", \":Oil Production\", \"{[Well]:Status} == 'Online'\", \"Well\"))<\/span><\/td>\n\u00a0<\/td>\n Error: Well 3:Status doesn't exist<\/strong><\/td>\n 3<\/b><\/span><\/td>\n 3<\/b><\/span><\/td>\n 7<\/b><\/span><\/td>\n 6<\/strong><\/td>\n \u00a0<\/td>\n \u00a0<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n