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

Previous Month MTD and Previous Year same Month MTD in rpd

Received Response
248
Views
15
Comments
2»

Answers

  • 3257177
    3257177 Rank 2 - Community Beginner

    Thanks Christian. But I am sure formula is correct. Because rolling 3 months, rolling 1 month and month ago is working perfectly.I will keep you posted  on monday along with screenshots which will include column formula and hierarchy.

  • Gianni Ceresa
    Gianni Ceresa Mod 
    3257177 wrote:But I am sure formula is correct.
    3257177 wrote:...but for previous Month MTD and previous year same month MTD is not working as expected.

    You are sure it is correct and you say it isn't working "as expected", but still you don't want to post the exact formulas you are using for the 3 cases...

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    sigh. amen.

  • 3257177
    3257177 Rank 2 - Community Beginner

    I wasnt having access to my system as I have already left for the day yesterday. So I have clearly mentioned in my last comment that I will paste formula and screenshots on monday.

    I have clearly mentioned that MTD formula is correct and is working as expected. Previous month Mtd and previous year same month mtd is not working. I have asked for suggestions on how can we achieve it.

    Thanks!

  • 3257177
    3257177 Rank 2 - Community Beginner

    Here you go.

    Below is the formula which we have used for MTD.

    ToDate("Warehouse"."Fact - Sales Order"."Sales Amount"."Warehouse"."Dim - Time"."Month")

    Hierarchy.JPG

    Please let me know on how can i create previous Month MTD and Previous Year same Month MTD