Annual Leave used (last 12 months)

[ashmitp869]

Hi ,

How can I calculate Annual Leave used (last 12 months) from the column "TOTAL_LEAVE_DAYS"

[sidhiq91]

@ashmitp869  Try using below Expression.

Count({<Date={">=$(=MonthStart(Today(), -11))<=$(=Today())"}>}Total_Leave_Days)