4 Replies Latest reply: May 4, 2018 2:14 AM by Prashant Sancheti RSS

    Sales for null  Customer based on following condition

    Prashant Sancheti

      Hi Team,

      I am having following condition

      • One Business Date which is always selected:
      • For that Business date, we are adding

           ITDTotal Sales =  Last Year Last date ITDSales value + YTDSales value for Current Business date 

      • Customer as Dimension
      • measure  as following


      num(Sum({$<BusinessDate={'$(=date(yearend([BusinessDate],-1), 'MM/DD/YYYY'))'}>}[ITDSales] +



      • Enable the null values for Bar Chart


      I want to show the


      • Total ITDSales in KPI (Including null)
      • How we can calculate TotalITDSales for null  Customer for above measure