1 Reply Latest reply: Jun 8, 2018 7:42 AM by Mariam Ovasheli RSS

    If Get selected

    Mariam Ovasheli

      Hello,

      I Want to Use Get Selected Function in my chart, So that When I Select YearMonth to see This this Month and previous month.

      My Formula looks like Something like this but it doesn't Work. Can you Please help me.

      IF(GetselectedCount(YearMonth)>0,


      ((


      AGGR(Sum({<Owner={'NeoGas'}, MonthNum={'$(=max(MonthNum))'}>}Volume),StationName)


      /


      AGGR(Sum({<MonthNum={'$(=max(MonthNum))'}>}>}Total Volume),District)


      )

       

      -

      (

      AGGR(Sum({<Owner={'NeoGas'}, MonthNum={'$(=max(MonthNum)-1)'}>}Volume),StationName)


      /


      AGGR(Sum({<MonthNum={'$(=max(MonthNum)-1)'}>}Total Volume),District)

      )),



      ((


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


      /


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


      )



      -

      (

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


      /


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

      )))