Creating YTD Calculation in Analysis Report

Sishiho Makoto · Oct 31, 2019 9:20AM

Good Day Expert,

How can I create a YTD column?

I want to get the total quantity from the current year up to current date but I can't seem to build it correctly.

This is the field that I want to have the YTD:

Let me know if you need further details.

Thank you.

[Deleted User] · Oct 31, 2019 9:26AM

RPD time series:

Joel · Oct 31, 2019 9:44AM

You’ll need to create these in your repository. You’ll also need a well formed time dimension that has hierarchy defined.

Take a look at @Gianni Ceresa‘s blog for some ideas .

Also, this blog describes how to use the TODATE function for YTD calculations: https://gerardnico.com/dat/obiee/obis/logical_sql/function_time

Joel · Oct 31, 2019 9:45AM

Beaten by @Christian Berg! Great minds think alike... (so they say)

Sishiho Makoto · Oct 31, 2019 10:00AM

Thank you for your inputs Sirs!

MFA for Oracle Community