2 Replies Latest reply: Mar 7, 2013 7:35 AM by James Waller RSS

    How do I display text and an expression in a text object?

      'AVG TIME:' & =time(avg(aggr(Interval(max(EventDate)-min(EventDate), 'mm:ss'), SessionID)),'mm:ss')

       

      This for example gives me :

      'AVG TIME:' & =time(avg(aggr(Interval(max(EventDate)-min(EventDate), 'mm:ss'), SessionID)),'mm:ss')

       

      When I would like my output of the text object to read

       

      AVG Time: 30:00

       

      for example...

       

      It seems successful if I do this the other way around, e.g.

       

      =time(avg(aggr(Interval(max(EventDate)-min(EventDate), 'mm:ss'), SessionID)),'mm:ss') & 'Is the avg time'

       

       

      why would the order matter so much? Seems very quirky.