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.
Answers (2)
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
Thanks Hobbsy
but there are no ticket rules in Asset management(or am I missing something).