[progress Communities] [progress Openedge Abl] Forum Post: Re: Calculate Sum Of A Field

  • Thread starter Thread starter john cruze
  • Start date Start date
Status
Not open for further replies.
J

john cruze

Guest
hi , i have an object name Appraisal having three field Rating ( pic list and their value is 1, 2, 3) , User (lookup field and relationship of user is "One user can have many Appraisal", Overall Rating ( where i want to calculate SUM of all rating divide by COUNT of all Rating and result assign into overall rating per user ). let say user 1 rating 2 1 3 --------------------- now overall rating calculated as (2+1+3) / (3) = 2 and same for user2 user 2 rating 3 3 3 --------------------- now overall rating calculated as (3+3+3) / (3) = 3 now what i want to see is User Overall Rating user1 2 user2 3 any help ? thanks.

Continue reading...
 
Status
Not open for further replies.
Back
Top