Jump to content

I'm trying to replicate this excel formula in Spotfire for a custom expression but it wont work! Help Pls!

Kom Son

Recommended Posts

The formula basically says that if a cell (count) in excel is = 0 then the new column should populate "no value". However, if the cell is not equal to 0, then the avg of a specified column should be calculated for all rows in the new column.

Spotfire custom expression I currently have is:


when [column_that_calculates_count] = 0 then "no value"

else avg([specified column])


What am I doing wrong

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...