DDSum(Input Values)<\/strong><\/p>\n Sums the input values for each timestamp. Typically this function is used on the return value of a DDGet() or DDGetAttributes() call since these functions can return multiple values for a single timestamp (by fetching the attribute of several entities).<\/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 Input Values: <\/b>A collection of values where each value contains the necessary metadata (see Useful to Know<\/a> below) which indicates the name of the source entity (DDGet<\/a>() and DDGetAttributes<\/a>() can produce such return values). How to format data types<\/a><\/p>\n An error will be thrown if:<\/p>\n In the calculation engine, values returned by DD() functions have metadata assigned to them, such as entity name and start\/end times. Other DD() functions can use this metadata to assign additional information to values they receive. In this way, the metadata is used by nested DD() functions to reduce complexity but increase versatility. Which metadata is used and how it is used is specific to each function, and is described in the Input Values section above, where applicable.<\/p>\n Expression: DDSum(DDGetAttributes(DDGetEntities(\"myHierarchy\", 2, \"rootEntity\"), \":myAttribute\"))<\/span> Tip: If you have access to the sample data, try running the following examples using the calculation tester<\/a>.\u00a0<\/p>\n Expression: DDSum({SampleDDGet})<\/span> Expression: DDSum(DDGet(\"P2 Corporate\", 5, \"Western Australia\", \":Oil Production\", \"{[Oil Producing Well]:Status} == 0\", \"Oil Producing Well\"))<\/span> The following table illustrates the difference between the Sum_Sampled<\/strong><\/a>(),\u00a0Sum<\/strong><\/a>(), and\u00a0DDSum<\/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 Sum_Sampled<\/a>() and Sum<\/a>() are calculated, refer to their respective pages.<\/p>\nReturns<\/h2>\n
Inputs<\/h2>\n
\nBehaviour: Required
\nDimensions: MultiCollection
\nValid data types: Decimal, Integer<\/p>\nError Conditions<\/span><\/h2>\n
\n
\n
\nThe type of the supplied VariableValue (\"Integer\") is not compatible with the type of the VariableValueCollection (\"Decimal\").<\/span><\/li>\n<\/ul>\n<\/li>\n<\/ul>\nUseful to Know<\/span><\/h2>\n
Examples<\/h2>\n
\nDescription: This expression produces a similar result to \"Sum<\/a>({childEntity1:myAttribute}, {childEntity2:myAttribute},... {childEntityN:myAttribute})\".
\nResult: Returns the sum of all fetched values of \"myAttribute\" for each child entity maximum 2 levels below the \"rootEntity\" in \"myHierarchy\".<\/p>\n
\nReturns: The sum of all fetched values in the SampleDDGet calculation tag. This tag is actually the same as the DDGet() function in the below example.
\nResult: 608.7259133387012<\/span><\/p>\n
\nReturns: The total oil production, for each timestamp, of each Oil Producing Well in Western Australia, in the P2 Corporate hierarchy, where the well is online (status is 0).
\nResult: 608.7259133387012<\/span><\/p>\nRelated Functions<\/h2>\n
\nDDSum(DDGet(\"Hierarchy\", 2, \"Field1\", \":Oil Production\", \"{[Well]:Status} == 'Online'\", \"Well\"))<\/span>
\nSum({Well 1:Oil Production},{Well 2:Oil Production})<\/span>
\nSum({Well 1:Oil Production},{Well 2:Oil Production},{Well 3:Oil Production})<\/span><\/p>\n
\nSum_Sampled({Well 1:Oil Production},\"Monday\",\"Friday\")
\nSum_Sampled({Well 2:Oil Production},\"Monday\",\"Friday\")
\nSum_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>
\nDDSum(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 Release History<\/span><\/h2>\n
\n
\n