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] +

          

      sum([YTDSales),'#,##0')


      • 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