Welcome to the Oracle Analytics Community

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

3371114 Rank 2 - Community Beginner

Comments

  • Thank you Richard for your help. I was trying to use the formula in a Filter and had even written it the way you'd recommend before I asked for help but was still unable to get it to work. I located an old report I used once before with a similar formula and got it to work in a Filter. Thanks again for your support.…
  • Thank you Christian for your help. I was trying to use the formula in a Filter and had already written it the way you'd recommend before I asked for help but was still unable to get it to work. However, I located an old report I used once before with a similar formula and it worked in a Filter. Thanks again for your…
  • Thank you Wendy for catching that. What I meant to say was that I'd tried "timestampadd(sql_tsi_month,-1,current_date)" in the filter portion of my analysis previously but could not get it to work, so I had to use the below formula instead which is working. "Submission Dates"."Hire Start Date" BETWEEN…
  • Saresh, Thank you for this information. I actually had tried the formula timestampadd(sql_tsi_month,-30,current_date) in the filter portion of my analysis but could not get it to work so I used the below formula instead and got it to work. Thanks again for the site information, I'll keep it handy for future use.…