4 Replies Latest reply: Dec 14, 2017 7:57 AM by Sunny Talwar RSS

    Percentage of calculated field

    surya j

      Hi

       

      I want a Percentage of Total Personal & Trade 'N' as well Total Personal & Trade 'Y'(Refer the below table).

      Account Type is a Calculated field.I wanted to create a % of Group field to show the percentage as i have mentioned in the below table.

        

      First Funded WeekWeek Ending 1/7/17
      Account Type - Excluding Mgd. AcctsTrade  Number of Accts Funded% of Group
      PERSONALN69,326 97%
      PERSONALY2,186 3%
      Total Personal 71,512
      IRA - Internal RolloverN6,493 96%
      IRA - Internal RolloverY305 4%
      Total IRA - Internal Rollover 6,798