17 Replies Latest reply: Mar 16, 2016 11:01 AM by Sunny Talwar RSS

    How to convert count(distinct(if($(ColumnDim4),inv))) to SET ?

    PAUL YEO

      Hi All

       

       

      I have below expression working fine , it return 28 or 36 depend on CY or YTD.

      count(distinct(if($(ColumnDim4),inv)))

       

      How to make the SET expression also return 36 ?

      COUNT(distinct{$<year = {$(=Max(year)-1)}, month = {"<=$(=Max({<year={$(=Max(year))}, sales = {'*'}>} month))"}>}inv/1000)

       

       

      Paul