6 Replies Latest reply: Jun 4, 2018 4:05 AM by Miskin Mazgaonkar RSS

    Aggregation Of Different Collumns

    Mariam Ovasheli

      Hello,

      I need to Calculate market share of certain station in a district Where it is. So I should Divide station's volume to volume of district where it is.

      This is my formula but it doesn't Work Can you Please help me


      AGGR(Sum({<Owner={'NeoGas'}, YearMonthMY = {'>=$(vStartDate)<=$(vEndDate)'}>}Volume),StationName)

      /

      AGGR(Sum({<YearMonthMY = {'>=$(vStartDate)<=$(vEndDate)'}>}Total Volume),District)