Hello.
I am trying to find the average budget margin from a specific segment and location.
I am trying to make a formula that calculates the average budget margin if the segment is "SEED" and the Location (number) is "> 0".
I tried using different variations of the following AverageIF formula:
=AVERAGEIF([Budget Margin]:[Budget Margin]; Segment:Segment = "SEED"; DK:DK = >0)
this doesn't work.
Does anyone know how I can achieve a correct formula? or is there another way to achieve the calculation?
Thank you in advance.
