Creating field which is a value dependent on other fields

I would like to have a field called weight or multiplier which takes the rank and priority and multiplies them together to populate this field. Does anyone know how to do this?
[176 byte] By [Jonny_B] at [2008-3-5]
# 1
I am starting to think that this is not going to work out - is it possible to do this through a query? Basically I want to sort by the highest rank * priority
Jonny_B at 2007-8-30 > top of Msdn Tech,Visual Studio Team System,Team Foundation Server - Process Templates...
# 2
I think that the way I could do this is by having a conditional value. Basically this is what I will need to do...1. have a field called Customer which will be by default 0, if there is a customer assigned to this work item, then set to 1.2. Create a query which will sort first by the field Customer, then by Priority and then by severity.This way, developers could come in in the morning and see their highest priority bugs (i.e. those associated with a customer) and do their work accordingly.Does anyone know how I can do the first part of this? Thanks in advance for your help.
Jonny_B at 2007-8-30 > top of Msdn Tech,Visual Studio Team System,Team Foundation Server - Process Templates...
# 3

Jonny, we do not have any "Expression" field types in V1, so you cannot create a field that displays product of two field's values.

Your approach will work well. Actually if there is a customer assigned in a field, you could set priority to 1. Workitem types can be customized with rules - here is link on how to customize wit types http://msdn2.microsoft.com/en-us/library/ms243849.aspx . Check especially field rule section at http://msdn2.microsoft.com/en-us/library/ms194953.aspx

NarenDatha-MSFT at 2007-8-30 > top of Msdn Tech,Visual Studio Team System,Team Foundation Server - Process Templates...

Visual Studio Team System

Site Classified