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