Calculate a field value in an asset record

I have requested for additional functionality in Asset Management that matches the custom rules in Service Desk tickets. In lieu of this being someway off, is there any way to calculate the value of a field in an asset record 

e.g. Cost of a widget x number of widgets = Total value (this would be the derived value) in the Asset Ticket. 

0 Comments   [ + ] Show comments

Answers (2)

Posted by: Hobbsy 5 months ago
Red Belt

Yes just use a ticket rule to calculate and populate the asset field with the answer. So you select the fields that contain the cost of widget and amount of widgets and then set the update statement to populate the total with a simple sum and use the WHERE statement to restrict which assets it does that to.

So using 1 as the widget cost, 2 as the widget number and 3 as the total, it should be as simple as saying




WHERE conditions

Posted by: kiwiblue 4 months ago
Second Degree Green Belt

Thanks Hobbsy 

but there are no ticket rules in Asset management(or am I missing something).

This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ