Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Below is my set analysis coding,
when i subtract Fiscal year It's subtracting from ASCII Code but actually i want subtract 1 year from my fiscal year, Highly appreciated if some one could me.
(sum({<YearFiscal={$(=Max(FiscalYear))}>} SalesMT)-sum({<YearFiscal={$(=Max(FiscalYear-1))},LastYTDFlag={1}>} SalesMT))/sum({<YearFiscal={$(=Max(FiscalYear-1))},LastYTDFlag={1}>} SalesMT)
Thanks,
Raju
Try this instead:
(sum({<YearFiscal={$(=Max(FiscalYear))}>} SalesMT)-sum({<YearFiscal={$(=Max(FiscalYear)-1)},LastYTDFlag={1}>} SalesMT))/sum({<YearFiscal={$(=Max(FiscalYear)-1)},LastYTDFlag={1}>} SalesMT)
But I'm sure that the Deployment Framework group is not the best place to place this kind of question