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

Need help on getting % chg on a calculated value in a text visualization


Guest

Recommended Posts

I have several calculated values on a text visualization but this one doesn't give the right answer.

 

product_reach.pdf

Here is my formula:

UniqueCount(if([item_Description2]='${ItemPromoImpact}',[CustNo], null))

/

UniqueCount([Cust_GeoCoordinate])

Each one of these formulas individually give me the right result. Even if I change the division for a sum or multiplication the formula works well, but when trying to divide it gives me 0

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...