Using filter selection within expression criteria

BenODBS — Mon, 20 Dec 2021 21:02:46 GMT

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

Re: Using filter selection within expression criteria

rwunderlich — Mon, 08 Mar 2021 18:22:56 GMT

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

Re: Using filter selection within expression criteria

BenODBS — Tue, 09 Mar 2021 09:35:26 GMT

Thank you so much!

topic Re: Using filter selection within expression criteria in App Development

Using filter selection within expression criteria

Re: Using filter selection within expression criteria

Re: Using filter selection within expression criteria