topic Re: get value less than or equal to selected ID_ANNO_SEMANA in App Development

get value less than or equal to selected ID_ANNO_SEMANA

cristianj23a — Fri, 10 Oct 2025 20:54:12 GMT

Hello, I need help.

I have a case where I have a filter, ID_YEAR_WEEK, configured to always retain a selected value.

But in the table chart, I want the following condition to be displayed in column "a."

That the values of the "TARA_POND" are displayed but only with the value less than or equal to the selected ID_ANNO_SEMANA, for example in this case I am filtering the ID_ANNO_SEMANA = 202545, then for the ID_PERIODOMENSUAL = 202512 it should show the TASA_POND of the ID_ANNO_SEMANA = 20245, not 202549 since it should be less than or equal to the ID_ANNO_SEMANA, the same in ID_PERIODOMENSUAL = 202511 it should show the "TARA_POND" of ID_ANNO_SEMANA = 20215, the same in ID_PERIODOMENSUAL = 202509 it should show the TASA_POND of the ID_ANNO_SEMANA = 202538 which its value is 0.58, since 202538 is less than or equal to 202545, so it should obey that condition when filtering another ID_YEAR_WEEK.

The results should be those with the red border in the image.

I would appreciate your help.

Regards.

Re: get value less than or equal to selected ID_ANNO_SEMANA

rubenmarin — Sun, 12 Oct 2025 06:53:58 GMT

Hi, you can try with:

FirstSortedValue(TOTAL <ID_PERIODOMENSUAL> {<ID_ANNO_SEMANA={"<=$(=Max(ID_ANNO_SEMANA))"}>} TASA_POND,-ID_ANNO_SEMANA)

If you want to show the TASA_POND as 0 for higher ID_ANNO_SEMANA values, you can add a condition like:

If(Only({1}ID_ANNO_SEMANA)>Max(TOTAL ID_ANNO_SEMANA) ,0 ,FirstSortedValue(TOTAL <ID_PERIODOMENSUAL> {<ID_ANNO_SEMANA={"<=$(=Max(ID_ANNO_SEMANA))"}>} TASA_POND,-ID_ANNO_SEMANA) )

Re: get value less than or equal to selected ID_ANNO_SEMANA

cristianj23a — Mon, 13 Oct 2025 14:37:14 GMT

Hi, it's the same as what I tried.
It doesn't meet the condition.

Regarts.

Re: get value less than or equal to selected ID_ANNO_SEMANA

rubenmarin — Mon, 13 Oct 2025 17:24:50 GMT

Hi, you should have something different, this is what I see using the expressions in your attached app: