Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

If & Len

Can anyone tell what is the issue in this formula?

 

Trying to extract the numbers then after looking at the first digit assign valid or invalid status
using it in custom column in editor
if (Text.Start(Text.Select([StoreCode], {"0".."9"})) ) = 5 then "Valid" else "Not Valid"

  • HotChilli's avatar
    HotChilli
    4 years ago

    Text.Start takes 2 parameters.

    5 is not a text value.

    That's my initial thoughts.

    Break it down to get it working, then build it back up

3 Replies

  • HotChilli's avatar
    HotChilli
    Community Champion
    4 years ago

    Text.Start takes 2 parameters.

    5 is not a text value.

    That's my initial thoughts.

    Break it down to get it working, then build it back up

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Yes i was missing the second parameter of count.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Tried "5" as well nothing changed.

     

    Formula isn't showing any error in syntax but when I apply it says

     

    Expression.Error: 1 arguments were passed to a function which expects 2.
    Details:
    Pattern=
    Arguments=[List]