topic Re: Function that works same AGO on obiee in App Development

Function that works same AGO on obiee

paulosilva — Sat, 16 Nov 2024 19:50:26 GMT

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 — Thu, 24 Oct 2019 08:39:29 GMT

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 — Thu, 24 Oct 2019 17:45:59 GMT

tks its works !