Custom Filter using AND error

HandsomeJih

Hi everyone, newbie here.

I tried using custom filter given multiple conditions, but it somehow fail for "malformed call".

I then attempt to change the data form but it doesn't work either, can someone help please?

I input below into the custom filter area:

(Length([ID number] = "7" AND Left([ID number], 1) = "9")

Thanks

Preparation

Accepted answers

atcodedog05

Hi @HandsomeJih

Try this formula

Length([ID number]) = 7 AND Left([ID number], 1) = "9"

Just a clarification you are trying to filter [ID number] of length 7 and starts with 9 right? if yes the above should work. Length is a number so it should be compared with 7 and not "7"

Hope this helps🙂

All comments

atcodedog05

Hi @HandsomeJih

Try this formula

Length([ID number]) = 7 AND Left([ID number], 1) = "9"

Just a clarification you are trying to filter [ID number] of length 7 and starts with 9 right? if yes the above should work. Length is a number so it should be compared with 7 and not "7"

Hope this helps🙂

philipmannering

Hey @HandsomeJih

You could try,

Length([ID number]) = 7 AND Left([ID number], 1) = "9"

You were missing a closing bracket around [ID number] and when you apply Length to a string field you return a number, so =7 not ="7"

Hope this works!

Philip

Emil_Kos

Hi @HandsomeJih,

In the situation like this if you don't know how to resolve the issue. Try splinting your formula in smaller parts.

First split your formulas into smaller parts. Like:

Length([ID number] = "7"

Left([ID number], 1) = "9"

Thanks to this approach you could identify which part isn't working correctly and probably you would be able to sort out your issue yourself 🙂

Good Luck!

Qiu

@HandsomeJih
Most likely, your "ID Number" field will be numeric, so we need to change it to string.

Length(tostring([ID number])) = 7 AND Left(tostring([ID number]), 1) = "9"

HandsomeJih

Thank you every one for quick response and advise!!!

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15875

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703