Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
Conditional Calculated Fields — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Conditional Calculated Fields

Received Response
edited Sep 11, 2019 5:22AM in Oracle Analytics 1 comment


Conditional Calculated Fields



I come from a Tableau background and am new to Oracle DV and I'm finding it difficult to create calculated fields the way I'm used to. I am trying to create a chart like this:

Headcount by Dept
2017 Q12017 Q42018 Q1Year Over YearYear to Date

I can get the counts for 2017 Q1, 2017 Q4 and 2018 Q1. However, I cannot calculate the Year Over Year or the Year to Date correctly. I have tried breaking the YoY into 3 calculations, one for 2017 Q1, one for 2018 Q1 and then the difference. I cannot get the correct counts for 2017 Q1 and 2018 Q1 that will match what is already in the chart. I am using the Quarter Name [Date], Active Headcount [Number] fields. I have a person number available, but could only use that if I ensure I'm counting only the active employees.

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!