Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
We are performing scheduled maintenance on our single sign on app. You man notice intermittent login issues. Thank you for your patience!
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Return a bespoke statement

binsell
8 - Asteroid

Hi All - I'm trying to find a formula to return 2 different bespoke statements. In my data, I have 2 (SCSFEE Gross and INVFEE (net) columns, one can have a value of =>0 and in the other column, a statement saying 'NO FEE UPLOADED LAST YEAR' can be either way around. If there is a value (including 0) I want to return the statement SCSFEE & INVFEE FROM LAST YEARS RETURN AS SPANNING COURSE SESSION and if BOTH columns say 'NO FEE UPLOADED LAST YEAR' then return the statement again 'NO FEE UPLOADED LAST YEAR' but in te=he column I want to add. Hopefully the data attached will make sense of what I'm trying to achieve. Thank you so much in advance :) 

2 REPLIES 2
Raj
16 - Nebula

@binsell 
find thw workflow attached
mark done if solved.

binsell
8 - Asteroid

Thank you @Raj You are brilliant! 

Labels
Top Solution Authors