I am trying to create a custom calculation similar to excel IF((AND(x,y,z)),sum,0). However, this type of formula does not appear to work in spotfire. Does anyone have any suggestions
The style that you used is more like Excel Formula.
IF(AND( x="Yes", y="2018"), sum,0)
While, in Spotfire, you can just type:
IF( x="yes" AND y="2018", sum,0)
Hope it helps.
Without much detail of the data you are using, perhaps the formula below may help you.
case when [col1]<>[col2] then Sum([col3]) else 0 end
In this formula the condition are (col1 <> col2), when true, will perform the desired sum, otherwise it will assign zero to the calculated column
I hope I have helped.
This Question already has a 'Best Answer'. If you believe this answer is better, you must first uncheck the current Best Answer