Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I need to get the average values of Fiscal Years. For a full fiscal year (e. g. 2018 which is from Oct 2017 to Sep 2018) this is no problem. But for the current fiscal year we have a definition to exclude the current month.
Let's say, we are currently in September of FY2019. I would need to get the average of all values for 2019 except the current month. This means: Data from Oct 2018 to Aug 2019 which has to be divided through 11.
Any hints how to do that? I have no clue. Thanks for helping.
Hi,
you can achieve this by creating a complex expression in your chart.
Or keep it simple, creat a flag in your script with
1 for all completed months
0 for actual (not completet) month
and calculate your average with
{<Complete = {1}>}
Regards