This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I have an alteryx app that I published on the company gallery. One of the parameters I am using is selecting two time periods. In the past, I allowed users to select only one quarter, which gets tagged as [PQ] and another quarter, which gets tagged as [CQ]. Then these [PQ] and [CQ] fields are used in many formula tools later in the workflow.
The users of the app now want to be able to select multiple quarters instead of just one quarter for [PQ] and [CQ]. So I have the below formula for the Formula tool, but there is no output. [PQ] and [CQ] inputs are "-1", which doesn't make sense.
What's happening is that you're asking if [Achievement Quarter] is one of those values and the "-1" is basically saying "no". I think you'll want to rewrite this as an IF statement to return the value of [Achievement Quarter]. Try something like this:
IF [Achievement Quarter] in ("20151","20152","20153") THEN [Achievement Quarter]
ELSE null() ENDIF
This formula for CQ will return the value of the [Achievement Quarter] if it's in the specified list and be null otherwise.
Thank you for your response. If I use your approach (List Box Tool, Formula tool with your formula), then it looks like all the quarters get selected, regardless of the quarters I choose on the app input popup page. And I don't know if it is related, but some of the calculations later on in the app don't work.