3 Replies Latest reply: Feb 6, 2018 10:17 PM by ahmad albab RSS

    Modify measure formula to show distinct value (only if same item NO)

    ahmad albab

      My measure formula:

      Sum(distinct(if(Gate='Gate D' and Status='Completed' and Temp='Task_17'and

      [Date Modified.autoCalendar.YearMonth]>= (AddMonths(MonthStart(Today()-20),-11))

      ,[SOW Value])))


      Value shown = 18,619,846



      How to modify my formula in order to get 19,230,824 ?


      awd.PNG

       

      cgcgc.PNG