help in the presentation of a sheet

[alejortizp]

Good day,

I am trying to show in a sheet the values of the ultimate year, but i want to sum all the selection i had taken. This is my sentence:

Sum({$<ANIO_PRESTACION += {max(ANIO_PRESTACION)}>} VALOR_APAGAR)

i was wonder if someone give me a light, so thanks you.

[giovanneb]

Hi, try this

Sum({<ANIO_PRESTACION = {$(=Max(ANIO_PRESTACION ))} >} VALOR_APAGAR)

If you're going to take this check, do it.

Sum({<ANIO_PRESTACION -= {$(=Max(ANIO_PRESTACION ))} >} VALOR_APAGAR)

Best Reguards

[alejortizp]

Thanks, but that just take a one year and not take all sum of the years i had selected. I want in the first look show the ultimate year and when select many years show the sum of the all years.

[giovanneb · Accepted solution]

Ok, try this

if(GetSelectedCount(ANIO_PRESTACION) > 1, Sum({<ANIO_PRESTACION = >} VALOR_APAGAR),

Sum({<ANIO_PRESTACION = {$(=Max(ANIO_PRESTACION ))} >} VALOR_APAGAR)

)

Best Reguards

[alejortizp]

You are right! Thank you very much i am glad