Previous Year

[#1]

I am trying to find the previous invoice total for August last year and have used the following expression

Sum({<[Bill Date]={">= $(=monthstart(Monthend(today()+1,-12))) <=$(=monthend(today()+1,-12))"},

Year = {*},
Period = {*},
Date = {*},
Month = {*},
[Calendar Year] = {*},
QuarterName = {*},
[LinkId] = {"FIN"}
>}
[Bill Value] * $(RevenueRate))

I could hard code the values in to year and month but I need this t be dynamic so when I run for September 2016 I get September 2015 invoice total as wel

Any ideas

[kaushiknsolanki]

Hi,

You should try this.

Sum({<[Bill Date]={">= $(=monthstart(Addmonths(today()+1,-12))) <=$(=Addmonths(today()+1,-12))"},

Year = ,

Period = ,

Date = ,

Month = ,

[Calendar Year] = ,

QuarterName = ,

[LinkId] = {"FIN"}

>}

[Bill Value] * $(RevenueRate))

Regards,

Kaushik Solanki

[#3]

Hi, Thanks but that has summed the totals up incorrectly as well