jeudi 9 février 2017

If statement not working in Spotfire

I hope you can help I am attempting to use an If statement in Spotfire. What I am trying to achieve is this

I have 13 unique numbers and what I am trying to say is that if column [GL_ACCOUNT(2)] = any of these 13 numbers then return me "Not EFPIA" in my new calculated column 'GL Account Filter'

It works up to two numbers but once i increase the amount of numbers the formula will not work.

My Code is below. As always any help is greatly appreciated

if([GL_ACCOUNT(2)]="0063304000","0063401000", "0062001000", "Not EFPIA") 

Aucun commentaire:

Enregistrer un commentaire