Help needed for calcultaion of quartiles In OAS

Michelle Alexandra Chicaiza Anrrango

Hello,

We are currently developing several reports using Oracle Analytics Server (OAS). As part of this task, we need to replicate reports from another BI platform.

However, we have encountered an issue with replicating calculations that involve the PERCENTILE and NTILE functions. Specifically, we need to replicate the following calculation from the old BI platform:

Percentile(([Nota de Admisión al Estudio que Cursa Actualmente]) ForEach ([Id Dato Cuartiles]); 0.25)

Despite trying various approaches, we haven’t been able to achieve the desired results in OAS.

Does anyone have experience with this and could offer some guidance?

Thank you in advance for your help.

P.S : For more context, we are working using only the analysis tool and interface.

Best regards,