Finding the percentage in a range

[daddioja]

I have a field with a number value. I want to calculate those values into a percentage equivalent based on the highest number in the range. So I have these numbers: 117, 94, 55, 103 in the field "value." I want 117, which is the highest to be calculated as 95%. Everything below that would be calculated as percentages based off that startign point. 94 would be 76% and so on. How can I make this happen? Thanks for any help.

[Ugo DI LUCA]

Hi,

Choose(ParentByConstant::value=Max(ParentByConstant::value),Round(1-(Max(ParentByConstant::value)/value-1),2),.95)

with ParentByConstant being a constant relationship.

[daddioja]

Thanks Ugo. I think I am going to have to look into those functions before I even try this. It seems a little above my head at the moment. I will try to play with it. Thanks for pointing me in a direction.