Oracle Business Intelligence

Products Banner

YTD Calculation on OBIEE 12c

Received Response
268
Views
3
Comments

I have a logical column in my rpd that should holds the YTD value. When i display this column in my report, it shows the value from the previous years to date, while I only require only the value from the beginning of the year specified. E.g. I have data from 2015 to date, and i want YTD. The value provided is a consolidation of 2015 Jan and Feb, 2016 Jan and Feb, 2017 Jan and Feb and 2015 Jan and Feb. The expression on my logical column is ToDate(measure,level)

Product version: OBIEE 12.2.1.1.0

Answers