Calculate total from other table list

[Dan Brown2]

Hi,

I was hoping for a bit of advice on the best way to achieve something.  

I have a list of records where the relevant fields are Amount (currency) and Year.

I then have another table where I want to create a record for each year, then this calculates the total for all totals for that year from the other table above.  I will create the record manually.

I have tried to create a UI Action without success - so I was wondering is something could please help?

Cheers,

Dan

[suvro · Accepted solution]

UI Action is a good option Use GlideAggregate to get the SUM using SUM aggregate

https://developer.servicenow.com/blog.do?p=/post/glideaggregate/

[Ankur Bawiskar]

Hi,

can you share what script did you try so far and what didn't work?

Regards
Ankur