Aggregate Formula for rolling 12 months
Hi I'm trying to change this YTD formula to be for the last rolling 12 months. I though that I could use a calculation on the Fiscal Month Number parameter but I can't find the right formula:
YTD(count_if("Tasks (Zoho Projects)"."Status" = 'Closed' AND "Tasks (Zoho Projects)"."Task Completion Mode" = 'On Time')/count_if("Tasks (Zoho Projects)"."Status" = 'Closed')*100,"Tasks (Zoho Projects)"."Due",1)
So I want to replace the 1 at end with the value of 12 months before the current month.
I thought about using abs_month(currentdate())-12 however it's not in the right format