Register to the Data Intelligence Summit Mexico City Register today to the Oracle Analytics Data Intelligence Summit in Mexico City on April 8th
Oracle Analytics was named as a Leader Oracle Analytics was named as a Leader in the 2024 Gartner® Magic Quadrant for Analytics and BI Platforms
New Oracle Analytics Release March 2025 New Oracle Analytics March 2025 release for Oracle Analytics Cloud and Analytics Server
Oracle Analytics Product Satisfaction Survey Share your experience and satisfaction with Oracle Analytics Product with our Product Satisfaction Survey

Oracle Analytics Cloud and Server

Calculate - Month LY Complete and FYLY Complete ?

Question

Views

Comments

Steelbird Rank 4 - Community Specialist

August 2021 edited August 2024 in Oracle Analytics Cloud and Server

Hi Team,

I have columns like MTD,FYTD,FYTD LY (these columns go by to_date formula in RPD) and I need to calculate Month LY - Complete(Ex - Aug2020 Complete) and Fiscal Year LY (Complete Year) (Ex - Mar2020 to Feb2021).

On the report I Will be passing only Date column So I cannot Use the Ago function for the above requirement.

Is there way to calculate these calculations either in RPD or Front end?

Thanks,

Steel.

Tagged:

OBIEE

Oracle Analytics Cloud and Server

Categories

Calculate - Month LY Complete and FYLY Complete ?