9 Replies Latest reply on Oct 13, 2018 8:15 AM by Jim Dehner

    Minimum sum

    Gavin Wong

      Hi Community

       

      without using window min or max

      how do i use a LOD to return the minimum sum for each year for the 4 regions ?

      i wrote

      { FIXED DATETRUNC('year', [Order Date]): Min([Sales])}

       

      and the results come back 1s or 0s.... which cannot be

      it should be

      2015: 103,838

      2016: 71,360

      2017: 93,610

      2018: 122,906

       

      so what went wrong ?