First of all, apologies if I'm posting too often. If there's a certain "cool-down" period that I need to adopt before posting again, please let me know.
I'm a bit stuck on something I'm finding very challenging. I just learned (attempted to at least) the Multi-Row & Field tools, and I didn't have a grand ol' time with that endeavor. I'm still trying to get my head round it - still trying to figure out expressions in the formula tool.
So, the instructions are as follows:
- Calculate [Costs] using the [Unit Cost], [Units Sold] and also the [Regional Uplift] multiplier
- Calculate [Revenue] by using [Units Sold] and applying the relevant Loyalty Bonus to the [RRP]
- Calculate [Profit]
Summarize your data to calculate [Total Profit] per franchise (retain the currency conversion amounts)
Then split into two workflow paths:
A) Using a combination of Sort and Multi-Row Formula assign the [Processing Priority] for each region.
Then output this file choosing a suitable name and file format.
B) Sort the franchises by [Total Profit], and convert this value to the relevant currencies
One of the glaring issues is about this loyalty bonus. I don't feel that enough information is given to make a determination about loyalty bonus. There are 3 categories of loyalty bonus 1, 3, and 5 years. Yet, the only piece of data we have on date is a month field. How am I to figure this out if I don't have any information about the year? Also, this bit about "applying the relevant Loyalty Bonus to the RRP," what do they want me to do? Multiply some percentage to the RRP value and then add that to the revenue? I'm not a finance guy, so I don't know anything about what to do with loyalty bonuses.
Also, can someone please tell me when to use a regular Formula tool vs the Multi-Field and Multi-Row formula tools? I feel the answer is pretty straightforward, but it really isn't for me.
I'll include the workflow that I have, along with the solutions. And as always, if it needs to be taken down, I'll do that right away.
hey @sameersheikh you will need to export your workflow as package so we can see the input data: Options > Export Workflow
Here's a little information on each tool:
Hope this helps provide some clarity. These tools make more sense, the more you use them. Try playing with all the interface tools (i.e. drop downs and check boxes in each too) and see how the output changes!
Let's break down the tasks and address the questions you have regarding loyalty bonus, the use of Formula tools, and Multi-Row & Multi-Field Formula tools in Alteryx.
Loyalty Bonus Calculation:
It seems like the Loyalty Bonus calculation is not explicitly defined in the instructions. However, you can make assumptions based on the available information. Since you have three categories of loyalty bonus (1, 3, and 5 years), you might assume that the Loyalty Bonus is based on the number of years the franchise has been active.
For example:
Please clarify this with your instructor or use your best judgment based on the information you have.
Formula Tool vs Multi-Row & Multi-Field Formula Tools:
Formula Tool:
Multi-Row Formula Tool:
Multi-Field Formula Tool:
Workflow Steps:
Calculate [Costs], [Revenue], and [Profit]:
Summarize Data for [Total Profit] per Franchise:
Split Workflow:
Processing Priority:
Output Processing Priority File:
Sort Franchises by [Total Profit]:
Convert Profit to Relevant Currencies:
Output Sorted and Converted File:
Thank you everyone for your responses. Truth be told, even the instructor was a bit befuddled as to how they came up with their workflow with respect to the discounts. I don't know, but I feel it's a poorly designed question. While I have the solution, I still can't make heads or tails of it.