HI @AjayKumar Maddipati - Thanks for your response. Helpful. I was however looking for Legal Seniority & Legal Hire Date. I have Enterprise Seniority/ Hire Date in my report already but would like to add the Legal ones too. Can you suggest on the above please? Regards, Abhishek

Hi @Nishanth B Jain - Thanks for your swift response. Will try this option at my end. This is helpful! Regards, Abhishek

Hi @Nishanth B Jain - Thanks for your response. I checked it, I think the scheduler option I see in OTBI at my end is different than what you showed in here. I feel the one you showed is from BIP, is it? Below is the one what i see in my scheduler - let me know if you have any idea around this one - thanks in advance!…

Hi @Amrita Gupta-Oracle - Also, in the meantime, i tried doing some alternatives to do the exclusion. I put up below formula so that i could exclude 1 & keep only 0 thru filter in Criteria page however when i see the output for below formulae, it only shows 0 for all records (whereas it should show 1 for 4 persons). Not…

Hi @Amrita Gupta-Oracle - No I didn't. I feel simple RCount is not providing what you see in the results at your end. Regards, Abhishek

Hi @Amrita Gupta-Oracle - I am afraid, because when I use this one, i only see value as 1 for all records (incl. duplicates).. am i missing something in here?

Hi @Amrita Gupta-Oracle - thanks so much for your response, this is really helpful. However, when i applied this, i do get results like below (which is what you mentioned in your response already). Wondering: is it feasible to get an output for the duplicate records as 1,2,3.. intent is to take them out through the report.…

Hi @ravikiran goda-Oracle - i didn't. where can i check this, can you advise pls? thanks in advance. Regards, Abhishek

Hi @Mandeep Gupta - You're right, I will now use the country code from Location description to do a country mapping thru SQL. REgards, Abhishek

Hi @Priscila Terazawa-Support-Oracle - No worries - thanks for your response & assistance. Regards, Abhishek