For YTD Target Achieved you can use this:
RUNNING_SUM(SUM([MRR]))/[ARR - Targets]
For Remaining FC Achievement, the way you describe it can be calculated like this (this accounts for the fiscal year starting in September):
([ARR - Targets] - sum([MRR])) / datepart('month',dateadd('month',-8,datetrunc('month',attr([Date]))))
However I don't understand the "(in %)" part of that field name. The results are mostly over 1 million for each month for that field so I'm not sure what you're looking for a percentage of.
Thanks so much!
Your solution for Remaining FC Achievement (in %) is perfect! Thanks!
I do not think I explained the YTD target achieved formula the best.
In the denominator, I always want to see the September 2018 ARR Target value which is 41.9M regardless of the month. Is there a way to always have this in the denominator without hard-coding it in? I need this as my real workbook has multiple years worth of data in it. Thanks!
Boom! Thanks again Shin!
Quick question - do you offer private consultant work?