Forum Discussion

mgrayTCB's avatar
mgrayTCB
Helper IV
2 years ago

Measure variable not working as expected

I am trying to write a measure that calculates yoy change by property. I am filtering out yoy’s that are beyond a threshold because there is probably something odd going on with those yoy’s values. O...
Need Help
mgrayTCB's avatar
mgrayTCB
Helper IV
2 years ago

I am not following your argment. Unless I am missing something both the 1step and the 2steps measures work off the same logic in NRRI YOY%. In the 1step measure I think I am just taking the last variable and _AverageWithinThreshold and avering it by property.  In the 2step measure I am just refereincing the NRRI YOY% measure and doing the same thing that the result is doing in the 1Step measure but ending up with different answers in the total row and cant figure out why.

mgrayTCB's avatar
mgrayTCB
Helper IV
2 years ago

Here is a simpler example of the same problem (or more likely something fundimental that I am missing). In the table below 47.5% is the average of the average of each property and the answer I am trying to get without writing two measures and having the second one reference the first one. What am I mssing?

-----------