Using filter selection within expression criteria

[BenODBS]

Afternoon,

I am trying to write an expression where when the user selects a dropdown list of values that consists of 1 to 100, the expression will calculate against it.

value table is;

case_id, value

1, 2, 3, 4, 5 etc

I set this as a filter called value

separate to that is the case table where I use the below expression.

count({$<[Field1]={'Completed'}, [Field2]={'A'},  [Duration]={"<=[value]"}>} [Case Ref])

I have tried variables with SET DUR = ([value])

and using expression  [Duration]={"<=$(DUR)"}

but I'm having no luck. 

Is it even possible to do?

thanks

[rwunderlich · Accepted solution]

count({$<[Field1]={'Completed'}, [Field2]={'A'},  [Duration]={"<=$(=Max(value))"}>} [Case Ref])

[BenODBS]

Thank you so much!