Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear All.
I want to apply the thisyear expression in given chart with growth but the data is not coming properly...
PFA
Thanks
=(SUM({$<FinancialYear=,FiscalYear={$(=max(FiscalYear))},
Date={">=$(=YearStart(max({$<FiscalYear={$(=max(FiscalYear))}>}Date),0,4))<=$(=max({$<FiscalYear={$(=max(FiscalYear))}>}Date))"}>}Values )/10000000) / (Sum({$<FinancialYear=,FiscalYear={$(=max(FiscalYear)-1)}
,Date={">=$(=YearStart(max({$<FiscalYear={$(=max(FiscalYear))}>}Date),-1,4))<=$(=addmonths(max({$<FiscalYear={$(=max(FiscalYear))}>}Date),-12))"}
>}Values )/10000000)-1