Alteryx Designer Desktop Discussions

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

Report Text Tool with a Formula

BrandonS4
8 - Asteroid

I am trying to add a header to a report using the Report Text Tool.  I need to have a formula in front of the header that gives me the name of the previous month.  The month will go in front of the report name which will always be the same.  I am not able to get a formula to work.  Does anyone know how to fix this? 

 

Thanks!

3 REPLIES 3
Jonathan-Sherman
15 - Aurora
15 - Aurora

Hi @BrandonS4,

 

You could achieve this by using the report text tool and selecting the field containing your month value to bring in as a variable in the text:

 

JonathanSherman_1-1641332073788.png

 

This would generate a header of:

JonathanSherman_2-1641332098220.png

 

I've attached my workflow for you to download if needed!

 

Kind regards,

Jonathan

BrandonS4
8 - Asteroid

@Jonathan-Sherman I am already using the report text tool after my layout tool.  Does that matter?

Jonathan-Sherman
15 - Aurora
15 - Aurora

Could you share your workflow? It might make it a little easier to diagnose

Labels
Top Solution Authors