Dividing Specific Variable Cell by Fixed Cell

Question

I have attached an excel file that shows what I want to do in Alteryx.  For example, for cell F2, I get that result by using the following equation =C2/$B$31.  I would need both new columns created "Send Metric" and "Receive Metric" by using the formulas shown in excel.  The input data may vary a little for each excel input file I use, but the format would usually remain the same and contain a lot of the same Categories as shown in Column A.

Output.csv

Luke_C · Accepted Answer

Hi @macst245

You could isolate the 'Total' row and append it back for each record. From there it should be easy to do the calculation.

Luke_C · Accepted Answer

Hi @macst245

Yes, you would use a formula tool to do the division. For the second point, instead of connecting the T output anchor of the filter to the T anchor on the append fields tool, just connect the input directly to the append fields and the total row will stay. Give it a go and let us know if you have any issues.

I'd highly suggest reviewing the 'Getting Started' learning path in the academy.