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

Using Distinct for OTBI reports

edited May 15, 2019 7:41AM in Reporting and Analytics for HCM 6 comments

Summary

We want to see only one result for specific areas

Content

Hi All,

I have one report about absences and balances which belongs departments. 
We used Sum for some specific areas and got the same result for each rows and now we want to see only one of them because all of them have same results.

I tried to edit formula and use Distinct but it didn't work. (Our each columns about absences have a little bit complicated formula.) I tried to use group by but it didn't work either. Actually it seems to easy what I am trying to do however I couldn't find a proper way to do it.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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