/build/static/layout/Breadcrumb_cap_w.png

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 3 years ago
Red Belt
0

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

UPDATE ASSET etc

SET

ASSET_DATA_3 = ASSET_DATA_1*ASSET_DATA_2

WHERE conditions

Posted by: kiwiblue 3 years ago
Fourth Degree Green Belt
0

Thanks Hobbsy 

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

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

Share

 
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