AnsweredAssumed Answered

Aggregation based on status attribute

Question asked by Shruthi on Jun 17, 2009
Latest reply on Jun 23, 2009 by Dave
Hi,  Is it possible to have a field which will have the sum of an attribute for all the instances based on another attribute?  For example,  the project object has ROI. We need to have the sum of the ROI  for all the projects based on the 'approved' status.  If we use the aggregation option, it sums up the ROI for all instances irrespective of the status. We need to sum the ROI only for the 'approved' projects.  How can we go about this?    Thanks,Shruthi Message Edited by nymphadora on 06-17-2009 06:08 AM [left]