Hi,
I am struggling with converting some Excel formulas to Alteryx. I am creating a tracking file in which daily activity will be uploaded and then formulas need to be applied on a line item basis. I need to create some pricing and running totals, but then there are additional calculations in which under certain conditions (sales) you use an average price/unit, which is a calculated field based on running totals. I tried t do a series of multi-row formulas and formulas, but I still am getting incorrect data as I have not figured out how to break down these dependencies in Excel into individual steps in Alteryx.
I have attached a file with my data set along with the formulas that I am trying to get into AYX. The green highlighted columns are the data that will be uploaded into the process. The yellow highlighted columns are the formulas that need to be applied, of which I am having issues with 4 of the formulas and have them labeled in the file.
Any suggestions?
Thanks!
