I have LIST 1 on which I need to do some summary statistic and put this in LIST 2, like shown below (only small sample to illustrate):
I've wanted to do this using MS Flow, but I don't see proper function for calculating Average in Math section. "Compose" do not provide such option. I've tried by initializing variable for Average and wanted to update it using "Set variable" with formula
=AVERAGE([DELIVERY_DELAY_DAYS]) but that is not accepted. Can you suggest how to do this?
Important note: I need to calculate Average for values in LIST 1 <> 0