Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI all,
i want one analysis Current year Vs Previous Year but in this i want suppose CY i having 4 month as Per Fiscal Year Apr,May,Jun,July 2015,
Now i want PY should contain Same Four month which as Current Year, Not Full year..
How i can do this??
please suggest
jagan mohan <span class="icon-status-icon icon-mvp" title="Mvp"></span> <span class="icon-status-icon icon-partner" title="Partner"></span> wrote:
Hi,
Try this expressions
Current Year:
Sum({<Year=, FiscalYear=, Month=, Quarter=, DateFieldName={'>=$(=YearStart(Today(), 0, 4))<=$(=Today())'}>} Sales)
Current Year:
Sum({<Year=, FiscalYear=, Month=, Quarter=, DateFieldName={'>=$(=YearStart(Today(), -1, 4))<=$(=YearEnd(Today(), -1, 4))'}>} Sales)
Replace Year, FiscalYear, Month, Quarter and DateFieldName with your actual field names.
Hope this helps you.
Regards,
Jagan.
Hi jagan
Is this Previous Year?
Current Year:
Sum({<Year=, FiscalYear=, Month=, Quarter=, DateFieldName={'>=$(=YearStart(Today(), -1, 4))<=$(=YearEnd(Today(), -1, 4))'}>} Sales)
?
Hi,
It is for Previous Year
Sum({<Year=, FiscalYear=, Month=, Quarter=, DateFieldName={'>=$(=YearStart(Today(), -1, 4))<=$(=YearEnd(Today(), -1, 4))'}>} Sales)
Regards,
Jagan.