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

    Expression result in text object different from Chart Object

      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])),