Screening criteria

• 10/13/2021 at 12:15 PM #179574
  montela

  Hi,

  I need to use a criteria for a screening (I see on forum you can use only one criteria) but can’t make it work.

  C1 = a = 1
  C2 = b = 1
  C3 = c = 0

  SCREENER[c1 AND c2 AND c3] (a as “RSI5”)

  I need to put multiple values in my screening something like SCREENER[c1 AND c2 AND c3] (a and b and c as “RSI5”).

  If someone with experience can give me hint, it will be a big help.

  Thanks,

  Ionut

  

  montela

  Participant

  Topics: 2

  Replies: 3

  Been thanked: 0 times
  10/13/2021 at 12:16 PM #179575
  montela

  I don’t need it like a criteria, to sort something, I need it more like a dashboard.

  

  montela

  Participant

  Topics: 2

  Replies: 3

  Been thanked: 0 times
  10/13/2021 at 12:37 PM #179578
  Nicolas

  The value of the sorting criteria will be a unique value and not separated.

  The only way to deal with 3 boolean values would be to multiply the first 2 ones, example:

  if a is equal to 1 and b equal to 1 and c equal to 0, the sorting critera could be wrote as : 110

  so in this case, just code it this way:

  criteria = a*100 + b*10 + c SCREENER[c1 AND c2 AND c3] (criteria as “RSI5”).

  1 2	criteria = a*100 + b*10 + c SCREENER[c1 AND c2 AND c3] (criteria as “RSI5”).

  not tested!

  

  Nicolas

  Keymaster

  Topics: 81

  Replies: 20828

  Been thanked: 4741 times
  10/13/2021 at 1:14 PM #179584
  montela

  Thank you! It’s working, the only problem is if I use more criteria I received a format like this: 1,111k. There is a solution to change this?

  Thanks,

  

  montela

  Participant

  Topics: 2

  Replies: 3

  Been thanked: 0 times
  10/13/2021 at 2:35 PM #179589
  Nicolas

  No sorry.

  

  Nicolas

  Keymaster

  Topics: 81

  Replies: 20828

  Been thanked: 4741 times
• Author
  Posts