Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Calculate - Month LY Complete and FYLY Complete ?

Question
9
Views
0
Comments
Steelbird
Steelbird Rank 4 - Community Specialist
edited Aug 13, 2024 7:10PM 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: