Global Asset Update (NM0530)

Hi,

Is there a way of globally updating an asset based on another attribute within the same asset based on size?
Example:

A gate is 1.2 m wide. (The width being a numeric field in the asset metamodel)
Needs its Actual Value updating (again another numeric field in the metamodel)

But we need to update all Wooden/Timber gates using the following crieria

Timber Gates < 1.0m = £ 500.00

Timber Gates >1.1 and <2.0 = £1000.00

Timber Gates >2.01 and < 3.0 = £2000.00

etc......

Mark