The sum formula works like summarize, in that in looks at the data one level down and creates a value on the parent.
Format:
-
sum ( attrName )
-
sum ( attrName.dataPoint )
The attribute being summed needs to have a numeric value itself.
Examples:
-
sum ( StormRole.Qualified )
-
sum ( NumQualified )
Reminder
The formula, attribute name and data point must be spelled and in the same case as the formula, attribute or data point you are referencing.
E.g. If an attribute is called CrewType, in the formula, you must use CrewType. crewType and CREWTYPE will not reference the CrewType attribute.
Comments
0 comments
Please sign in to leave a comment.