Aggregate Formula: SUMIF date matches last month

Aggregate Formula: SUMIF date matches last month

Hello,
I was trying to sum only data that match last month. In SQL I was able to do it, but I was wondering if this is possible with Aggregate Formula also.

This would be an example of what I was trying to do (which did not work):
sumif(Month("Steering_MasterDB"."Date")=(Month(getdate())-1), "Steering_MasterDB"."Revenues Actual",0)
I am open to any suggestion as long as I get the same result.

Thank you
Kastriot