8 Replies Latest reply: Dec 22, 2014 7:34 AM by Wande Sulu RSS

    Expression result in text object different from Chart Object

    Wande Sulu

      Hi all,

       

      Please kindly assist me,

       

      If I put the expression below in a text object it returns 114 - This is right based on Excel calculation.

       

       

       

      =Count({$<[Previous Month] = {'Telephone'}>} [Sales Date])

       

      However, if I put any of the expressions below in a Straight table they return 94.

       

      Count({<[Previous Month] = {'Telephone'}>} [Sales Date]),
      Count({$<[Previous Month] = {'Telephone'}>} Sales Date]),
      Count(if([Previous Month] = 'Telephone',[Sales Date])),