Sum_Sampled(Expr ,StartTime [,EndTime])<\/strong><\/p>\n Note: This function was named\u00a0Accum\u00a0<\/em>in v2.6.<\/p>\n Returns the sum of the values of an expression over a range of time.<\/p>\n It is possible to retrieve very large volumes of data through indiscriminate use of this function. Retrieving large amounts of Historian data across a slow network can affect system performance for all users of the system.<\/p>\n Expr<\/strong>: The expression whose values should be summed.\u00a0Which values are summed will depend on how the expression is sampled. StartTime<\/strong>: The start time over which to produce the sum. EndTime<\/strong>: The end time over which to produce the sum.\u00a0If not specified, it assumes the current time. How to format data types<\/a><\/p>\n An error will be thrown if:<\/p>\n Expression: Sum_Sampled(Expr, Time() - 60, Time())<\/span> Expression: Sum_Sampled(Expr, Time() - 60)<\/span> Expression: Sum_Sampled(Expr, Midnight(Time()))<\/span> Expression: Sum_Sampled({tag, sampleMethod = \"Raw\"}, Time() \u2013 60)<\/span> Expression: Sum_Sampled(Sampling(Expr, \"raw\"), Time() - 60)<\/span> The following table illustrates the difference between the Sum_Sampled<\/strong>(),\u00a0Sum<\/strong><\/a>(), and\u00a0DDSum<\/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 Weekly Oil Production for a well<\/strong>: Total Daily Oil Production for all online wells<\/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<\/a>() are calculated, refer to their respective pages.<\/p>\n <\/p>\n","protected":false},"excerpt":{"rendered":" Use Sum_Sampled() to get the sum of the values of an expression over a range of time.<\/p>\nReturns<\/h2>\n
Inputs<\/h2>\n
\n Behaviour: Required
\n Dimension:\u00a0Collection
\n Valid\u00a0data types: Boolean, DateTime, Decimal, Integer, String, Duration<\/p>\n
\n Behaviour: Required
\n Dimension: Collection, SingleValue
\n Valid data types: DateTime, Decimal, Integer, String<\/p>\n
\n Behaviour: Optional\u00a0
\n Dimension: Collection, SingleValue
\n Valid data types: DateTime, Decimal, Integer, String<\/p>\nError Conditions<\/h2>\n
\n
Examples<\/h2>\n
\n Result: Sum\u00a0over the last minute (60 seconds)<\/p>\n
\n Result: Sum\u00a0over the last minute (60 seconds)<\/p>\n
\n Result: Sum\u00a0since midnight (the start of the day)<\/p>\n
\n Result: Sum\u00a0of the raw values over the last minute<\/p>\n
\n Result: Sum\u00a0of the raw values over the last minute<\/p>\nRelated Functions<\/h2>\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 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\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