Question

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

  • 30 March 2022
  • 0 replies
  • 10 views

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 

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)


This topic has been closed for comments