Forum Discussion

HEW's avatar
HEW
Icon for Helper III rankHelper III
4 years ago

Calculate deviation% based on first available value

Hi.   I am trying to calculate the deviation% from the first available value compared to the last available value in selected period.   As you can tell from below matrix, the first row in the mat...
Whitewater100's avatar
Whitewater100
Icon for Solution Sage rankSolution Sage
4 years ago

Hi Helen:

 

I'm wondering if you are able to share any data (data model layout) and sample data? I beleive you might need a disconnected table with item, price, price start date, price end date.

 

Thanks!