Sunday, March 11, 2012

choose max value of multiple calculations

Hi,

I need to be able to get the maximum value of different calculations.

Example :

i have 5 calculations like this :

(sum(Fields!CountTest1.Value)/sum(Fields!TestCount.Value))*100

(sum(Fields!CountTest2.Value)/sum(Fields!TestCount.Value))*100

(sum(Fields!CountTest3.Value)/sum(Fields!TestCount.Value))*100

(sum(Fields!CountTest4.Value)/sum(Fields!TestCount.Value))*100

(sum(Fields!CountTest5.Value)/sum(Fields!TestCount.Value))*100

these calculations give me a percentage from a test value against the total test values.

what function or expression can i use to get the max value of all the calculations ?

I was looking at the "choose" function but i'm not quite sure how...

anybody ? help ....

Vinnie

Hi again ...

I found a solution to my problem.

the way to do this is by using the following expression:

=math.max(value1, math.max(value2, math.max(value3, math.max(value4, value5))))

in fact it is the max function that is standard in the math expressions from rs.

greetings.

Vinnie

No comments:

Post a Comment