I am trying to simply create a calculated field using ifelse() but keep getting a syntax error. when I look through other people’s formulas they all have the same structure as what I am using. What am I not seeing? Here is my formula:
The portion highlighted as error is just the parameter name.
My end goal is to create a formula that allows me to switch the date aggregation on charts and tables and I would like to swap between month, quarter, year and ytd. Any additional support in the rest of the code would be appreciated as well.
Thanks for your reply. However, it doesn’t seem to make a difference in my instance. I’ve remade the parameter and even rewrote them in a different dataset and analysis and this still didn’t work.
Hey, working on a similar problem here.
So, the conclusion here is that parameters cannot be used to do what bmike4 and I are trying to do (that is, have multiple static values defined for the parameter that the user can select from, which then works within a simple ifelse statement to help filter our data). Do I understand that correctly?
Because defining multiple acceptable values for a parameter inherently makes it a multi-value parameter and thus unusable in basic conditional statements?
