Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Alteryx Formula Tool

STAR1BANU
8 - Asteroid

Dear Experts,

 

I need to create the formula new big multiple headers with using if function attached is the sample workflow but my output data type should be in fixed decimals 

 

I am getting error in the formula itself also one more thing if I change the data type from string to fixed decimal getting conversion error waring in Alteryx what is the best for that,  please provide the solution in the workflow it will be helpful.

 

Thanks for your help....

2 REPLIES 2
Shifty
12 - Quasar

Hey @STARBANU

 

There appears to be two issues:

1. You're using inverted commas around a number when you don't need to

2. You're referencing the field you're creating within the formula

 

If you remove the inverted commas, your formula is validated as below:

Shifty_0-1620496500970.png

 

However, you get an error because the field "New Revenue + Profit for the year 2021" hasn't been created yet.

 

How you get around this depends on what you're trying to do but start with not referencing the "New Revenue..." field in your formula.

 

I know I haven't completely fixed your issue but hopefully I've pointed you in the right direction for you to resolve yourself.

vizAlter
12 - Quasar

Hi @STAR1BANU — Try this solution with Fixed Decimals:

 

Also, using a "Select" tool (after the "Input Data" tool) is always helpful to know about the data type of each field.

 

vizAlter_0-1620521416033.png

 

Please mark this solved if it helps.

 

Labels