Traverse through each row to calculate change

Question

Hello,

The Challenge -> For each product, I'd like to flag if there was a change to the 'amount' over the months.

I could use a multi-row formula to see if the balance changed month over month for 12 months but sometimes I only have data for 4 months.

I have attached the input and desired output in this post.

Check if all rows contain same value.yxmd

AngelosPachis · Accepted Answer

Hi @amadra ,

What I would do is look if for each product you have more than one values appearing - you can do it with a summarize tool, group by product and count the distinct amounts that appear.

Then if that count is greater than 1, that means there was a change.

Hope that  helps,

Angelos

rfoster7 · Accepted Answer

You don't even need a multi row tool Just do a Summarize tool, group by Product and get Min(Amount) and Max(amount). then use a formula tool to make a status of "No Change" if the min = max and "Change" if it isn't.

If you need something more complicated like, is the change positive, or how many changes or longest time between changes, then you need the multi row tool.

phottovy · Accepted Answer

Hi @amadra , the multi-row tool was my first instinct and I think you could use it to get your intended result. Instead though, I used a summarize tool to find the min and max for each product. If the min equals the max, then there was no change. I attached my version of the workflow.