Date

[#1]

Hi I have this for this year to date,  what would be the code for last year to date please.

{$(#vYearThisMonth)}

[Agis-Kalogiannis]

I think that you need to become more specific on that.

Could you please give us some more information?

Thanks

[robert_mika]

Try those links:

Year to Date vs Year to date Last Year

Calculating rolling n-period totals, averages or other aggregations

[#4]

{$(#vYearThisMonth)} this is a expression to show me information based on year to date.  i don't know how that expression should be to show me year to date last year.

would it be something like {$(#vLastYearThisMonth)}?

Thanks.  PS appreciate all your help

[robert_mika]

Frankly speaking this is not an expression this is  a variable use as expression.

You can name your variable as you wish.

Check this place:

Settings-Variable Overview or

Settings -Expression Overview

and you will see how this variable has been defined.

[#6]

Thanks I found the information

{$(#vYearThisMonth)} = =Year(MonthEnd(Today()))      //

count ({<[PV_Case.Quote Year] = {$(#vYearThisMonth)}, [PV_Case.Quote No_Prefix] = {SQ}, [PV_Job_Calculation_Detail.Line Type] = {1}, PV_Job.Status_List = {Quote},PV_Job.Active_List = {Yes}>}[PV_Job.Quoted Price])

{$(#vYearLastMonth)} = =Year(MonthStart(Today())-1) //

count ({<[PV_Case.Quote Year] = {$(#vYearLastMonth)}, [PV_Case.Quote No_Prefix] = {SQ}, [PV_Job_Calculation_Detail.Line Type] = {1}, PV_Job.Status_List = {Quote},PV_Job.Active_List = {Yes}>}[PV_Job.Quoted Price])

I seem to be getting the same values this year and last year.  What have I don’t wrong?

Regards

Tyrone

[robert_mika]

Look at this topic

Year to Date vs Year to date Last Year

and Steve Dark post about YTD