11 Replies Latest reply: Aug 15, 2016 9:46 AM by Joanna Seldon RSS

    expression based on filter and osuser

    Joanna Seldon


      Hi

       

      I only wish to sum on person logged in

       

      I have a text box that shows show's who's logged in via a windows login using

       

      domain = OpenWorld

      Username =jo111111

       

      on text box expression is

       

      osuser()

       

      this gives me UserDirectory=OpenWorld;UserId=jo111111

       

      I have a filterpane called UserId that contains jo111111

       

      there is a chart showing sales, my expression is like this, but it does not work I only wish to sum on person logged in

       

      sum ({$<OSUser= {UserID}>}SALES)

       

      how can I get this to work please