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

[Kom Son]

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:

case

when [column_that_calculates_count] = 0 then "no value"

else avg([specified column])

end

What am I doing wrong

[Shrutika Aggarwal]

Could you please tell me if there is any error message

[Fabian Duerr]

I expect you get different output types. And a column can only hold one data type.

"no value" is a STRING,avg([whatever_numeric_column]) is a REAL

So, either replace "no value" with NULL. Or wrap STRING() around your average expression.