Dynamic Year

[#1]

Hi all

I'm using this formula to calculate our last year revenue:

Num(sum({<Fact.Type = {'Sales'}, Calendar.Year = {2013}>} Fact.Net_Rev_EUR), '#''##0.00')

As I want to have it dynamic I tried this, but this doesn't work:

Num(sum({<Fact.Type = {'Sales'}, Calendar.Year = year(today())-1>} Fact.Net_Rev_EUR), '#''##0.00')

I'm sure somebody can tell me why?

thanks for your help

Oliver

[tresesco · Accepted solution]

try:

Num(sum({<Fact.Type = {'Sales'}, Calendar.Year = {'$(=year(today())-1)'}>} Fact.Net_Rev_EUR), '#''##0.00')

[its_anandrjs]

Try like in SET analysis

Num(sum({<Fact.Type = {'Sales'}, Calendar.Year ={'$(=year(today())-1 )'} >}  Fact.Net_Rev_EUR), '#''##0.00')

In set analysis you can't write like

Calendar.Year = year(today())-1

Regards

Anand

[jagan]

Hi,

Try this

=Num(sum({<Fact.Type = {'Sales'}, Calendar.Year = {$(=Year(Today())-1)}>} Fact.Net_Rev_EUR), '#''##0.00')

Regards,

jagan.