how to exclude a value

[#1]

I have a field which has certain values like so :

TYPE = { dev, prod, test}

How can I exclude only test from this field in my template?

[iktrayanov]

Use expression like

if(match(TYPE,'dev','prod'),TYPE)

Regards,

Ivan

[#3]

Thanks.. but there are more values in the field than what I have given above around 15 of them and I have to exclude just 'test' it would be easier if there was a function just to exclude the value 'test'

[Alejandro_Hernández]

SUM({<TYPE-={'test'}>} Value)

[iktrayanov · Accepted solution]

If (TYPE <> 'test', TYPE)

[#6]

Thank you