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?

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.

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

Hi wayne,

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