1 Reply Latest reply: Jun 29, 2012 11:47 AM by Kiran Rokkam RSS

    Text object expression

    Hardik Gandhi

      Hi,

       

      I am using the following expression (TEXT OBJECT):

       

      =sum(aggr(count(distinct if( CalendarMonthName= vCurrentMonth and CalendarYear = vCurrentYear,[Message Person ID])),Date)) 

       

      I want to make it fixed value so it should only show the output for CalendarMonthName= vCurrentMonth and CalendarYear = vCurrentYear and should not get updated even I make any field selections in the application.

       

      Thanks,

      H

        • Re: Text object expression

          You can try this:

           

          =sum(aggr(count(distinct {1<CalendarMonthName= {"$(=vCurrentMonth)"} and CalendarYear = {"$(=vCurrentYear)"}>} [Message Person ID]),Date)

           

          I think aggr function isnt required as your are using in text box. If you have any specific reason ignore this comment.

           

          Regards,

          Kiran Rokkam.