nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle AI and Analytics

Child Item

DV Calc using Power inplace of Root

Wayne Van Sluys

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

I found this for using POWER in place or ROOT

But I get a value of 1 back

Any Suggestions?

Find more posts tagged with

Accepted answers

Jerry Casey

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

All comments

Jerry Casey

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

Wayne Van Sluys

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.

Multiply: 2 * 4 * 10 = 80
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

Hi wayne,

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

Upcoming Event

Oracle AI World 2026
Where AI meets business outcomes Oracle AI World brings the Oracle community together to explore how AI and other technology innovations are driving real business outcomes across industries. Discover what’s new through: Mainstage keynotes to hear the latest directly from Oracle leadership Product demonstrations Customer…

Top Leaders