7 Replies Latest reply: Jan 13, 2011 1:23 PM by John Witherspoon RSS

    How to display the top account name in a Text box

    Yogalakshmi Narayanasamy

      Hi All,

       

      I want to display the Name of the Account with the top Sales number in a text box

      i am using the below expression

       

      Top Account = '& If(aggr(rank(sum(sales)),AccountName)<=1,AccountName,null())

      But the text box looks blank. what could be the reason?