Function that works same AGO on obiee

[paulosilva]

Hi, i need a function that works finding values on a range date, type a one year ago and sum the values. 

AGO("FACT"."VALUE", "MONTH"."YEAR", 1)

[thi_pham · Accepted solution]

sum({<[Date.autoCalendar.YearsAgo]={1}>} VALUE).

It will depend on where you intend to use this statement, but generally it is something like that.

[paulosilva]

tks its works !