Hi, could someone help to understand why the number type variable does not work in formulas?
Here it is:
why
Filter(Accounts;ID_Employee = LookUp(Employees; NamePApps = User().FullName; ID_employee); ID_City)
DOES work, but
Filter(Accounts;ID_Employee = 21; ID_City)
DOESN'T ?
I see LookUp(Employees; NamePApps = User().FullName; ID_employee) is equal number 21 and has a number type. What is the problem here?
Hi @Maxlos ,
Assuming that the field ID_Employee is a Number type, then what you're doing is correct and the filter should work.
But if the field type of "ID_Employee" is a Text, then the formula won't work, to make fix it you can enclose your value in Text function or use double quotes if it's a static text.
Share
Report
All responses (
Answers (
1,008
Filter(Accounts;ID_Employee = Text(21); ID_City)
or
Filter(Accounts;ID_Employee = "21"; ID_City)
Hope you find this helpful! 🙂
Kind Regards,
Shaik Sha
________________________________________________________________________
If I have answered your question, please mark the post as Solved.
If you like my response, please give it a Thumbs Up.
