Hi all
I'm a beginner Alteryx user and I got most of my workflow going but I'm having trouble trying to convert a column into the basic unit of measure for our sales.
I need to replace the values in our sales table based on a characteristic of our Product master table.
So I have a work flow that looks like this
The sales table looks like this
the product master table looks like this
After referencing the product table, I need to record my sales in cases only so the sales table will look like this at the end
I appreciate in advance any suggestions that I can get on this.
Best regards
Francisco
Solved! Go to Solution.
Hi @fmarin00, you could just write a simple formula after your join of the two tables that says something like IIf([SaleUnit]="BOT", [SaleQty]/[Bpecase],[SaleQty])
Thanks for the suggestion. I also replaced BOT by CS in the sales unit column of the sales table using a similar formula