Skip to main content
L
linp0001
February 3, 2022
Question

check if element is 0 in an array

  • February 3, 2022
  • 3 replies
  • 0 views

Hi there,

I know I can use any function to check any element is null in an array like this:

any(fn!isnull, {0, null, 30}).

how to use any function to check if any element is 0?

Thank you.

Lin

3 replies

agamb0001
agamb0001
February 3, 2022

Hi Lin,

You can try something like:

or({0,null, 30}=0)

OR


contains({0,null, 30},0)

L
linp0001Author
February 3, 2022

Thank you.

harshitb6843
harshitb6843
February 4, 2022

Hi there,

You can you the contains() to just get true and false. You can also use whereContains to get the index of the element that is 0. 
There are many more methods to do this but really depends on your use case here. 

Terms & ConditionsAccessibility statement