You’re offline. This is a read only version of the page.
Announcements
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
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?
Share
Report
All responses (
Answers (
2,297
