Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Ok, try this
if(GetSelectedCount(ANIO_PRESTACION) > 1, Sum({<ANIO_PRESTACION = >} VALOR_APAGAR),
Sum({<ANIO_PRESTACION = {$(=Max(ANIO_PRESTACION ))} >} VALOR_APAGAR)
)
Best Reguards
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
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.
Ok, try this
if(GetSelectedCount(ANIO_PRESTACION) > 1, Sum({<ANIO_PRESTACION = >} VALOR_APAGAR),
Sum({<ANIO_PRESTACION = {$(=Max(ANIO_PRESTACION ))} >} VALOR_APAGAR)
)
Best Reguards
You are right! Thank you very much i am glad