Oracle Analytics Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Analytics Forums› Oracle Analytics Forum

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
1
Views
0
Comments
Steelbird
Steelbird Rank 4 - Community Specialist
edited Aug 13, 2024 7:10PM in Oracle Analytics Forum

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: