-
1. Re: Anyway to create formula in filter that will accept multiple params
Zhouyi Zhang
Feb 5, 2018 3:21 PM
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
-
2. Re: Anyway to create formula in filter that will accept multiple params
I created the P_Period parameter as you advised, but I cannot commit the formula due to errors. Any advice?
-
3. Re: Anyway to create formula in filter that will accept multiple params
Zhouyi Zhang
Feb 5, 2018 4:06 PM
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
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?
-
5. Re: Anyway to create formula in filter that will accept multiple params
Zhouyi Zhang
Feb 5, 2018 5:33 PM
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
-
