Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

How to sum the costs of assets owned by an employee? Edited

We need to track expenditure on assets per employee per year. For that I tried to use the following smart value to print in an audit log action, just to check if I am on the right track. But it doesn't produce any results:

So this -> Sum of costs: {{lookupObjects.Cost.sum}}

Procuces this -> Sum of costs: 

Where the lookupObjects are the assets of an employee.

Where did I go wrong here?

P.S. {{lookupObjects.size}} gets the correct count of objects, which proves the lookup to be true

These alse did not work:

{{lookupObjects.object.Cost.sum}}

{{lookupObjects.it.Cost.sum}}

1 answer

Hi Amir,

Can you share your rule and are you using insight? 

Quick Reference on lookup issues and insight: https://support.atlassian.com/jira-service-management-cloud/docs/smart-values-insight/ 

Hi Fabian,

Yes, I am using Insight and here is my rule:

A4J Insight.png

I have scoured the A4J documentation related to Insight as well as lists functions and I was led in this direction -> {{lookupObjects.Cost.sum}} 

BTW, the Lookup Objects action has the following query: Owner = {{object.Owner}}

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Jira Service Management

Atlympic Event: Jira Service Managemnt

Hello Community!  Quick disclaimer: We are running a contest on Community (The Atlympics!) from July 23rd - August 8th of 2021. If you are interested in participating in this contest (prizes! ...

339 views 5 6
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you