Can we divide two rows data?

akumar2609

Hi Team - I need help in dividing the data available in two different rows.

Months	Jan	Feb	Mar
Num	10	20	30
Den	5	5	10

Result expected

Months	Jan	Feb	Mar
Num	10	20	30
Den	5	5	10
Error Rate	2%	4%	3%

jrlindem

@akumar2609 - Yes, we can certainly do this.  It's a lot of steps and tools for what seems like something simple, but you need to break this down into three pieces:

1. The main data rows

2. The blank row

3. The calculation

Once you have that, then you can start to build each piece.  I have a lot of filler tools that could probably be consolidated down, but I think it helps teach the concept so you can adapt to other use cases.  This should also scale as you get/add more months.

The basic concept though is using the combo of Transpose and Crosstab to flip your data so you can compute it then you flip it back to your original format.  RecordID helps you maintain the final order:

I've also attached the workflow for your reference.

Hope this helps, -Jay

jrlindem_example.yxmd