show the value with in limit or show the maximum value if after the limit

[Anonymous]

I have 2 columns ID and value out of which i want only those id whoes value is less than 4 and if value is 4 or greater than 4 then only show id and value of maximum one

[HoangHugo]

Hi, try this

show_value =

var select_value = SELECTEDVALUE(value column)

var select_ID = SELECTEDID(ID column)

return IF(MAXX(FILTER(table, ID column = select_ID),value colum)>=4,MAXX(FILTER(table, ID column = select_ID),select_value)

[Anonymous]

This is not working for me

[HoangHugo]

Hi, modifiy a bit

var select_value = SELECTEDVALUE(value column)

var select_ID = SELECTEDVALUE(ID column)

return IF(MAXX(FILTER(table, ID column = select_ID),value colum)>=4,MAXX(FILTER(table, ID column = select_ID),select_value)

if still not, can you share screen of error.