# Formula or Function to calculate a trend from historical data

I am currently trying to calculate rate of leave taken of prior periods and compare it against corresponding months across different years. I was wondering if someone knows of a function or formula that works best for this?**Rate of leave taken **= Accrued liability reversals(taking leave)/ Previous month(FINAL Existing hrs)

**Source Module**

Used the time module to map distinguishing dimension.

**Target Module**

Thank you!!!

0