4 Replies Latest reply: Dec 16, 2012 8:42 PM by Bob Bottelsen RSS

    Applying only the selections from one data field to the data set

      Hello, I have a set expression formula like this:  Avg( {1<[Project Model Name] = {"$(#vProcessName)"}>} [Project Duration] ) .  This will take the average of [Project Duration] from the entire data set, ignoring all selected data values except for those where [Project Model Name] equals the value of the variable vProcessName.  This works well when there is only one selected value for [Project Model Name] that I can assign to the variable vProcessName.

       

      I'm looking for a set expression that will allow me to apply multiple selections for [Project Model Name] and still ignore all the other selected data values in the data set.  Thanks!