Hi Team,
I have Fiscal Year like : 2020-2021, 2021-2022.
Now I my expression is like - SUM({$<FiscalYear={"2021-2022"}>} FHC)
I don't want hard code of year.
I tried by using variable, But My variable is not working. In my Script I have used for this fiscal Year =
Num#(YearName(Link_Date, 0, 4)) AS FiscalYear
Please suggest how I can make the expression for current fiscal year.
Thanks.