Min value in set analysis

[#1]

Hi all, could some body help me whit this, I have this expresion,

sum

({$<AGRUPADOR={'01_VENTAS'}>}DATA_AVER)

/

SUM ({$<AGRUPADOR={'01_VENTAS'}>}Total DATA_AVER)

What I need is to get the minimum value of the expresion, I tryed with a variable but doesn´t work.

vVar =

sum({$<AGRUPADOR={'01_VENTAS'}>}DATA_AVER)

/

SUM ({$<AGRUPADOR={'01_VENTAS'}>}Total DATA_AVER)

=min($(vVar))

any ideas??

[ToniKautto]

Please notice that Sum() is an aggregation funciton which will return a numeric value, and not a range of values in a vector. This means that your variable vVar will have a numric valu or NULL (if the denominator sum() is 0). If you are trying to find the min value you first of all need to look in a range of values like in a field or an aggregated vector by using aggr().

It is a bit unclear what the surrounding conditions are in this case, and what value your are expecting to get, so please provide a sample QVW with data and the related object to enable a more detailed feedback and guidance.

[#3 · Accepted solution]

Hola Javier,

Ya trataste con

MIN(Total AGGR(sum( (DATA)/ (DATA TOTAL) ),dimensión))  ?

La dimensión es muy importante, no sabemos como está definido el conjuno al que se le busca el mínimo.

Espero que ayude la idea.

Saludos