6 Replies Latest reply: Apr 18, 2018 12:47 AM by Poojashri Bangera RSS

    Set Analysis Upper Bound

    Poojashri Bangera

      (Sum({<[Finance Date] ={">=$(=YearStart(AddYears(max({<FiscalQuarter=,FiscalQuarter=>}[Finance Date]),-1),0,4))<=$(=AddYears(max({<FiscalQuarter=,FiscalYear=>}[Finance Date]),-1))"},

      FiscalQuarter=,FiscalYear=>}[Service Revenue])/avg({<[Finance Date] ={">=$(=YearStart(AddYears(max({<FiscalQuarter=,FiscalQuarter=>}[Finance Date]),-1),0,4))<=$(=AddYears(max({<FiscalQuarter=,FiscalYear=>}[Finance Date]),-1))"},

      FiscalQuarter=,FiscalYear=>}USD_RATE))/1000000


      This expression gives me YearStart(AddYears(max({<FiscalQuarter=,FiscalQuarter=>}[Finance Date]),-1),0,4)='4/1/2016'

      and this expression gives AddYears(max({<FiscalQuarter=,FiscalYear=>}[Finance Date]),-1)='2/28/2017'


      when i sum(revenue) for this date it should give me 2.10k

      but my set analysis is excluding upper bound while summing revenue i.e '2/28/2017'(It is not considering this date)

      only from '4/1/2016' to '1/31/2017' it is summing up revenue.


      please help