Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
Need for all your help,
How to write expression with previous YTD in financial year (start from July end June)?
So, if I click Month : Jan 2013, so it will sum from July 2011 until Jan 2012.
I had success write YTD for current year with this expression :
sum({<Month,FinancialMonth={"<=$(=only(FinancialMonth))"}>} Amount)
Thanks before.
Regards,
Heri
Hi,
You can try this expression.
Sum({<Date = {">=$(=Yearstart(Max(Date),-1,6))<=$(=addmonths(Max(Date),-12))"},Month=,Year=>}Sales)
have a look at the attached example.
Regards,
Kaushik Solanki
Hi,
You can try this expression.
Sum({<Date = {">=$(=Yearstart(Max(Date),-1,6))<=$(=addmonths(Max(Date),-12))"},Month=,Year=>}Sales)
have a look at the attached example.
Regards,
Kaushik Solanki