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 to calculate the average value with some condition in one column


Recommended Posts

If there are some rows data is same, I only want to use one data to calculate the avaerage: pls check the attachment. if use all data to calculate the average value, it will be not same I want tocalculate the non zero like this (3303+367+71630)/3 instead of (3303+0+0+0...+367+0+0....+71630+0+0+0+0...)/n
Link to comment
Share on other sites

×
×
  • Create New...