I have a straight table, where i have to show avg of last 12 months stock values.
Expression : =$(v_KPI_Stock_24M_Precalc)/ if (Fiscal_Year=VScript_24MStock_FYo,v_NumMonths_CurrentFY,12)
In my project Fiscal Year Starts from October.
If the user want to see 2017 Data, Fiscal Year starts from 2016 Oct . It's all fine.
The Problem Is if we want 2018 data it should show from 2017 oct to 2018 Feb. But Its showing data upto March . I want to exclude Un completed month. How can i write expression.
Do you have a month field? How do you define "uncompleted" - on a calendar or by last update?
Its much harder to debug and suggest solutions for an expression using variables. I suggest that you get the expression working with literal values; once you have a working baseline, then you can consider using variables if needed.
Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
