Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Get the value of a variable without using sum

Guys,

Im using the this function to get the length of a player between certain ages (vLengthLow and vLengthHigh(

    Sum({<LENGTH ={">=$(vLengthLow)<=$(vLengthHigh)" }>} LENGTH)

This works but now I only get the sum. And I would like to have just the value. So a little like

   LENGTH

but then with the variables included.

Any thoughts on how i can fix this?

1 Reply
sunny_talwar

May be this:

Sum(DISTINCT {<LENGTH ={">=$(vLengthLow)<=$(vLengthHigh)" }>} LENGTH)


or


Only({<LENGTH ={">=$(vLengthLow)<=$(vLengthHigh)" }>} LENGTH)