Labels

[kev6brown]

I have labels that show text like -

Market - 123456

Market - 2345

Market - 3456789976543

Market - 143425245

How do I only show what comes after the "-" in a bar chart in Sense

Thanks

Kev

[Chanty4u]

try

create below in script   and use  that field in your chart

subfield(FieldName,'-',2)  as Number

[kev6brown · Accepted solution]

=Right(FieldName,Len(FieldName)-Index(FieldName,'-')) worked