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 Analytics and AI

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.