Hi
I am struggling with an IN expression for a Dashboard view.
Its my first time trying it and I cannot seem to get it right
if(
ISBLANK(ANY(User Purchases Dashboard Filter[Query_ILI_Allocation])),TRUE,IN([ILI_Allocation],ANY(User Purchases Dashboard Filter[Query_ILI_Allocation]))),
This one does not return anything when I choose an option from my enumlist.
I've checked and the user table where I am entering the filter value matches the value in my Allocation table in the case of my example being ALL001 but nothing is returned.
What is wrong with my expression?
These are the other expressions I've used and they seem to be working.
AND(
If(
ISBLANK(
ANY(User Purchases Dashboard Filter[Query_Store_Name])),TRUE,[ILI_IT_Link].[Invoice_BFTD_Link].[BFTD_Store_Name]=ANY(User Purchases Dashboard Filter[Query_Store_Name])),
If(ISBLANK(ANY(User Purchases Dashboard Filter[Query_Start_Date])),TRUE,[ILI_LineItemDate]>=ANY(User Purchases Dashboard Filter[Query_Start_Date])),
If(ISBLANK(ANY(User Purchases Dashboard Filter[Query_End_Date])),TRUE,[ILI_LineItemDate]<=ANY(User Purchases Dashboard Filter[Query_End_Date])),
if(
ISBLANK(ANY(User Purchases Dashboard Filter[Query_ILI_Supplier_Name])),TRUE,[ILI_Supplier_Name]=ANY(User Purchases Dashboard Filter[Query_ILI_Supplier_Name])),
if(
ISBLANK(ANY(User Purchases Dashboard Filter[Query_ILI_Product])),TRUE,[ILI_Product]=ANY(User Purchases Dashboard Filter[Query_ILI_Product])),
if(
ISBLANK(ANY(User Purchases Dashboard Filter[Query_ILI_Allocation])),TRUE,IN([ILI_Allocation],ANY(User Purchases Dashboard Filter[Query_ILI_Allocation]))),
if(
ISBLANK(ANY(User Purchases Dashboard Filter[Query_ILI_Expense_Type])),TRUE,[ILI_Expense_Type]=ANY(User Purchases Dashboard Filter[Query_ILI_Expense_Type])),
if(
ISBLANK(ANY(User Purchases Dashboard Filter[Query_ILI_Payment_Type])),TRUE,[ILI_Payment_Type]=ANY(User Purchases Dashboard Filter[Query_ILI_Payment_Type]))
)
Solved! Go to Solution.
Regarding the first expression:
Just get rid of your ANY()s.
Regarding the first expression:
Just get rid of your ANY()s.
Hi Joseph,
Thanks for the response. When I remove the ANY() from
ANY(User Purchases Dashboard Filter[Query_Store_Name])),TRUE,[ILI_IT_Link].[Invoice_BFTD_Link].[BFTD_Store_Name]=ANY(User Purchases Dashboard Filter[Query_Store_Name])),
Appsheet gives me "Cannot compare Ref with List in ([ILI_IT_Link].[Invoice_BFTD_Link].[BFTD_Store_Name] = User Purchases Dashboard Filter[Query_Store_Name])"
@Joseph_Seddik wrote:Regarding the first expression :
๐
User | Count |
---|---|
37 | |
31 | |
29 | |
22 | |
18 |