cancel
Showing results for
Did you mean: Helper I

## % of Growth with Alpha Value

Hi!

Working on something where I need a percent growth between different tests. What we want to see change on is an alpha value though, so not sure how to work out how we can show the change. Here's an example. Right now we have 3 different tests that are labeled as windows. The 1st was an "I" then for the 2nd and 3rd they have a "J". So they moved up a level for the 2nd window but not the 3rd. Is there a way we can have this displayed, and also have a percentage of individuals who moved up a level?

Thanks!

2 ACCEPTED SOLUTIONS Super User II

Try this:

First a calculated column to get an index, assuming you window column works as it seems:

`Index = RIGHT(Test[Window];1)`

Then i make another calculated column:

```Upgrade =
VAR index = Test[Index]
Return
IF(CALCULATE(SELECTEDVALUE(Test[Ind. Level]);ALL(Test);Test[Index]=index-1) = BLANK() ; "No Upgrade" ;
IF(
CALCULATE(SELECTEDVALUE(Test[Ind. Level]);Test[Index]=index) <> CALCULATE(SELECTEDVALUE(Test[Ind. Level]);ALL(Test);Test[Index]=index-1) ;
;
))```
This calculates based on index, assuming that you have more than one person participating in these tests you will need to implement that into the index so that it looks at each person/window individually.

Hope this helps! 🙂  Super User II

That implies that there you are comparing text with number format! I think it's the new index column that is in text format and not number. Change it to number and see if it works!

6 REPLIES 6 Super User II

Try this:

First a calculated column to get an index, assuming you window column works as it seems:

`Index = RIGHT(Test[Window];1)`

Then i make another calculated column:

```Upgrade =
VAR index = Test[Index]
Return
IF(CALCULATE(SELECTEDVALUE(Test[Ind. Level]);ALL(Test);Test[Index]=index-1) = BLANK() ; "No Upgrade" ;
IF(
CALCULATE(SELECTEDVALUE(Test[Ind. Level]);Test[Index]=index) <> CALCULATE(SELECTEDVALUE(Test[Ind. Level]);ALL(Test);Test[Index]=index-1) ;
;
))```
This calculates based on index, assuming that you have more than one person participating in these tests you will need to implement that into the index so that it looks at each person/window individually.

Hope this helps! 🙂  Helper I

Hi!

From the screenshot you have on the bottom that upgrade column is what I'm looking for. I'm having trouble with creating the columns though, not sure if I need to follow yours exactly or edit it.  Community Support

Best Regards

Maggie Helper I

I replaced it with a comma and was able to get that first column.

For that second column that @tex628 created I was getting a similar error so I replaced the semicolons with commas again. Now I'm getting this error:  Super User II

That implies that there you are comparing text with number format! I think it's the new index column that is in text format and not number. Change it to number and see if it works! Helper I

It did, thank you!  