How do I get the sum of Insight attributes?

[Laura López]

I've created a Object schema for licenses, so I can easily track the licenses that a user has assigned and its cost.

I can get the list of the software and the cost with this:
{{#lookupObjects}}
* {{Name}}
* {{Cost}}
{{/}}

I would like to get the sum of the cost of these licenses, somehow the list.sum isn't working for me: 
{{lookupObjects.Cost.sum|0}}

Other list smart values like .size are working for me. Can someone help me? Thanks! 

[Krister Broman _Advania_ · Accepted solution]

Unfortunately the sum function does not appear to work with lookupobjects.

Workaround:

Create a variable, in this variable use a sum field. Set the variable to 0 as start just for safety.

Example:

Variable Name: SumTotal
Attribute Name: Price

{{#=}}{{SumTotal}}{{#lookupObjects}}+{{Price}}{{/}}{{/}}

This will itterate over the price and put a + before each of them.

With
Object 1 with value 10
Object 2 with value 20
Object 3 with value 30

you would get 

{{#=}}0+10+20+30{{/}} which should give you total of 60. 

Also remember that this will be set as a text value in the variable so use .asNumber if you need to do further calculations or to set it into a numbers field/object. 

Another thing to look out for is empty values as that will mess up the calculation so in your query make sure to remove any object that does not contain value in the Price (example) attribute. 

[Rudy Holtkamp]

Thanks, I was running in circles, but this helped me out!

[青山 明]

Did this issue get resolved?
I am also facing this issue.