Formula tool

[Tim6]

Hi There, 

I have data where each person can have a different rate each month: 

ID           Jan Rate   Feb Rate   March Rate  April Rate 

Tim          4.75           4.75             4.75            4.75

Cassey    4.75           3.75             4.75            4.75

Yvonne    4.75           4.75 

For each person, I would like to know in which months there was a rate change.

I would also like to account for the possibility that the customer discontinues their services (ex. Yvonne - there was no rate in March or April but the same rate was used in Jan and Feb which means there was no rate change). 

Would you be able to help me out with this? 

Thank you. 

[Blake]

Hi @Tim6 

First you'll want to transpose your data and then use a multirow formula to evaluate. 

I've attached a workflow, let me know if it helps! 

[Tim6]

Hi Blake, 

Thank you so much for the below 

1) Is there a way i can know if there is an overall rate change for each person not month by month. 

2) and if there is a rate change i would like to know the month and rate. 

Thank you!

[Blake · Accepted solution]

Hi Tim, I think we can address both of those questions with 2 tools. I used a multirow formula to create a data point for each of the prior month's rates and then filtered to only include the month's where there was a change. 

There are definitely other ways to do this but I think this will be functional for you.