Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How do I calculate the pYTD (previous year to date) value?

Adam_KNov 14 2018 — edited Nov 14 2018

Hi,

I'm using Oracle Business Intelligence 12.2.1.0.0 and I'm struggling to calculate the pYTD.

I've managed to get the YTD value using ToDate("Measures"."Revenue", "Time Dimension"."Year"). I tried pairing this with AGO("Measures"."YTD", "Time Dimension"."Year", 1) to get the pYTD. However, it's giving me the previous full year value rather than the value up to this time last year.

Thanks in advance,

Adam

This post has been answered by Adam_K on Nov 14 2018

Jump to Answer

Added on Nov 14 2018

#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee

1 comment

348 views