Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I want to use set analysis for FTD,MTD,YTD calculations.
If anybody can provide script for this,would be great !
Regards
Praveen
Hi Praveen,
Below code will help you to do the requirement.
MTD = sum({$<Month_Year={"$(=monthname(today()))"}>} Sales)
YTD = sum({$<Fin_Year={"$(=(yearname(today(),0,10)))"}>} Sales)
Sridhar