I need to count the non #MI cells for the level0 descendants of upper level members. I am trying to calculate the averages for the upper members based on the input values of all the descendants lowest level members. My values would look something like this:
In order to get the average for the lvl2 member I need the sum of all lvl0 values divided by the count of all non #MI members. I can get the sum but not the count. I've tried this formula
"Avg BB" = @AVGRANGE(SKIPMISSING,"BB",@RELATIVE(@CURRMBR("Organization"),0)); Which gives me
the average of the organization members along the right column or
"Avg BB" = @AVGRANGE(SKIPMISSING,"BB",@RELATIVE(@CURRMBR("Time"),0)); Which gives me the average of the time members along the bottom row but how do I get the intersection of the both time and organization?