Creating YTD Calculation in Analysis Report

Sishiho Makoto

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:

• SUM("quantity")

Let me know if you need further details.

Thank you.

[Deleted User]

RPD time series:

https://gerardnico.com/dat/obiee/obis/logical_sql/function_time

https://gianniceresa.com/2017/01/time-series-functions-why-how-what-where-obiee/

Joel Acha

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   .

https://gianniceresa.com/2017/01/time-series-functions-why-how-what-where-obiee/

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

Joel Acha

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

Sishiho Makoto

Thank you for your inputs Sirs!