Introducing the all-new TIBCO Community site!

For current users, please click "Sign In" to reset your password and access the enhanced features. If you're a first-time visitor, we extend a warm welcome—click "Sign Up" to become a part of the TIBCO Community!

If you're seeking alternative community sites, explore ibi, Jaspersoft, and Spotfire.

Jump to content

How do you calculate an average value based on distinct values in another column

Andrea Thompson

Recommended Posts

Hi All,


In my data I have mulitple entities, with multiple rows of data, identified by "NUMBER" column. For each entity, I have two MD perforation values, Perforatoin Min and Perforation Max, that I need to use to calculate the average TVD value for all rows that fall between the Perforation Min and Max values on the MD column. I have written this line:

Column Name: TVD_Effective If(([MD]>=[Perforation Min]) and ([MD]

  • Like 1
Link to comment
Share on other sites

  • Create New...