Forum Discussion

felipecarvalho's avatar
felipecarvalho
Helper I
4 years ago
Solved

Error: Cannot apply the operator to the types Function and Function

Hi, good people 

I think my problem is not too complex, but I don't understand what is going on ...

 

Look at this formula 

 

 

At the moment the last Column is giving me the expected result.  

 

Focus on the 2 variables that I have in the second and third lines. I "Rename" to "A" and "B" in the picture to make it easier to explain.

On the picture above, I am returning  B, and the result is Fine (type is null or a number).  If I return A the result is fine too.

 

But I want to return B -A. 

 

But I Get this error:

 

 

How can I solve this?

 

Thanks for all your help!

 

 

Need Help
Tutorial Requests

2 Replies

    • felipecarvalho's avatar
      felipecarvalho
      Helper I
      4 years ago

      wdx223_Daniel 

       

      I use your suggestion like this and it worked:

       

       

      I think I still do not fully understand the "each" and (_).... and why they make it work...

      Can you elaborate?

       

      Regardless of that, I will already mark your answer as the solution. 

      Thank you very much!