-
1. Re: Anyway to create formula in filter that will accept multiple params
Zhouyi ZhangFeb 5, 2018 3:21 PM (in response to Robert Reid)
Hi, Robert
You need create a parameter P_Period with a value list Weekly/Monthly/Yearly, and then create a calculation
If [P_Period] = "Weekly" then
if [PERIOD_TYPE] = "Weekly" then 1 else 0 end
elseif [P_Period] = "Monthly" then
if [PERIOD_TYPE] = "Weekly" or [PERIOD_TYPE] = "Monthly" then 1 else 0 end
else
1
end
Hope this could help
ZZ
-
3. Re: Anyway to create formula in filter that will accept multiple params
Zhouyi ZhangFeb 5, 2018 4:06 PM (in response to Robert Reid)
Hi, Robert
I mean create a new calculation field instead of put the code in formula. Once you create the calculation field, drag it to filter and select 1.
ZZ
-
4. Re: Anyway to create formula in filter that will accept multiple params
Robert Reid Feb 5, 2018 5:02 PM (in response to Zhouyi Zhang)Hi ZZ, I added a workbook. II did my best following your instructions. What I am trying to accomplish is to restrict the table to display:
Weekly row, when param = weekly
Weekly and Monthly rows, when param = monthly
Weekly, Monthly and Yearly rows, when param = yearly
Can you advise where I went wrong?
-
fiter-formula.twbx 16.2 KB
-
-
5. Re: Anyway to create formula in filter that will accept multiple params
Zhouyi ZhangFeb 5, 2018 5:33 PM (in response to Robert Reid)
Hi, Robert
Your calculation is correct, the only thing you need to do is just filter the 0 out as shown below screenshot. An updated workbook attached for your reference.
Hope this could help
ZZ
-
fiter-formula_v10.2.twbx 14.8 KB
-
-
6. Re: Anyway to create formula in filter that will accept multiple params
Robert Reid Feb 5, 2018 5:59 PM (in response to Zhouyi Zhang)Thank you … you da man!