Changing how a field value is presented

[Anonymous]

How do I change how a field value is presented.  I have a field with two values: '1' or '0'.  I am using the following expression to show just the '0's but I don't want the label on my chart to show '0'.  I want to give it a different name.

=if(not Match(field1,'0'), field1)

Grateful for any suggestions.

Thanks

Greg

[alexandros17 · Accepted solution]

=If(field1='0','Name1', 'Name2')

.. but if you need this as label of the expression I think it will not work because field1 will show probably both values, in this case which one should be displayed? Add more detail and I'll help ...