Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

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

DV Calc using Power inplace of Root

Accepted answer
37
Views
3
Comments
Wayne Van Sluys
Wayne Van Sluys Mod
in Oracle Analytics Cloud and Server

I am trying create a calculation to get the nth Root of a value

I found this for using POWER in place or ROOT

 

image-40bbdb7eaf1fd-5db9.jpeg

 

But I get a value of 1 back

Any Suggestions?

Best Answer

  • Jerry Casey
    Jerry Casey Rank 6 - Analytics Lead
    Answer ✓

    If I use POWER(XXXX,1/3), I get 1.00. If I use POWER(XXXX,0.33333) I get the correct (approximate) answer.

Answers

  • Wayne Van Sluys
    Wayne Van Sluys Mod

    That is fine, I need the calc to be dynamic with the denominator changing.

    I am trying to calculate this measure where the number of patients could change per site.

     

    GMLOS (Geometric Mean Length of Stay) for healthcare report…

     Gather data: Collect the length of stay (number of days) for each patient within a specific group (e.g., patients with the same DRG - Diagnosis Related Group).

    Multiply the lengths of stay: Multiply all the individual lengths of stay together.

    Calculate the nth root: Determine the nth root of the product, where 'n' is the number of patients in the group. For example, if there are 5 patients, you would calculate the 5th root.

     Example:

    Let's say you have 3 patients with the following lengths of stay: 2 days, 4 days, and 10 days.

    1. Multiply: 2 * 4 * 10 = 80
    2. Calculate the 3rd root: The cube root of 80 is approximately 4.31.

     Therefore, the GMLOS for this group of patients is approximately 4.31 days

  • Jerry Casey
    Jerry Casey Rank 6 - Analytics Lead

    Hi wayne,

    If you use 1.00/x in the POWER function, rather than 1/x, it works as expected.