Can % Change Be Computed Using a Beastmode?

mfaas
mfaas Member

[see attached image]

 

Suppose I have this two column dataset: one column has the date and one has a quantity.

 

What I need is to take a quanitity, subtract the quantity corresponding to the month before, and then divide that difference by the quantity corresponding to the month before. This is the (new-old/old) way to compute % change.

 

Can this be accomplished in a Beastmode or ETL? It is my understanding that beastmodes are calculations can only evaluate that which is in the same row. Could I use a case to solve this?

 

 

 

 

Comments