1 Reply Latest reply: Feb 12, 2018 10:05 PM by Thiago Justen Teixeira RSS

    Subtitle expression.

    ahmad albab

      Hi. May I know why my number of task expression show different value when used in subtitle expression? What is the correct expression?


      It show 43. what i want is 36.5

      • 42+31=73
      • 73/2= 36.5


      Please help. Thanks,




      Expression for number of task:


      =Num(Count({$<[SR No]={"=Min ({<Temp = {'Task_1'}>}[Date Created]) >  MakeDate(2018,1,15)"}>


      *$<Status={'Completed'}>*$<[SR No]-={"''"}> *$<Temp={'Task_1'}>


      *$<[Date Modified.autoCalendar.YearMonth]={">=$(=AddMonths(MonthStart(Today()-20),-11))"}> }


      ([SR No])),'##.0')