ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
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