3 Replies Latest reply: Nov 2, 2016 4:45 AM by Sunny Talwar RSS

    OSUser - Set Analysis

    Paul Senior

      I'm trying to use Set Analysis to show sales for the user who is logged in, using the following code:

       

      sum({$<PAIDREPUser="{=SubField(OSUser(),'UserId=',2)}">}Sales)

       

      The SubField(OSUser(),'UserId=',2) returns the user correctly and the PAIDREPUser field also returns the right name in the right format. However, when I put them together in the Analysis set I can't seem to get any result.


      Any ideas what I'm doing wrong?