Solved: syntax help on ShowColumns and Filter

Just need some help on syntax and is this possible ?

ShowColumns(Filter('[dbo].[Rebate_Sales_Cond_Maint]', Sales_Adj_Selection_YN = "Y");
'[dbo].[Rebate_Sales_Cond_Maint]',"Selection_Text","Selection_Col_DBNames")

Thanks

Dave

Categories:

Using Apps Using Formulas

General Questions

The syntax of ShowColumns is ShowColumns(table, "column to show1", "column to show2") where table can be a filter. So it appears to me you are filtering the table '[dbo].[Rebate_Sales_Cond_Maint]', based on the column Sales_Adj_Selection_YN =containing a value of "Y". And it appears the fields you are wanted to return are "Selection_Text" and "Selection_Col_DBNames". You seem to have a extra copy of your table name after your filter.

So based on my interpretation of what I see above, it looks like your syntax should be

ShowColumns(Filter('[dbo].[Rebate_Sales_Cond_Maint]', Sales_Adj_Selection_YN = "Y"),
"Selection_Text","Selection_Col_DBNames")

Did I miss interpret what you are trying to accomplish?