Average of above 'n' values if a null is encountered

Hi, 

I am trying to insert a column where if a null value is encountered , it automatically takes an average of above ‘n’ values:

So, in this scenario 

34092375-d841-4e2d-8629-f0228858bfd7.png

The highlighted yellow should generate an average of (1.3 and 0.7) if the value is null otherwise the value (1.3/0.7)

0 0 52
0 REPLIES 0
Top Labels in this Space
Top Solution Authors