IF statements in labels

[jamesbarnett]

I am trying to create a label for slope ratios. I want to have the label show only whole numbers if it is a whole number and go to the 10th place only when necessary. Is there a way to use the label editor to do this?

I would think it would work something like

IF(<General Segment Grade>=0|1|2|3|4|5|6|7|8|9 then <[General Segment Grade(FRun|P0|RN|AP|GC|UN|SD|OF)]> else <[General Segment Grade(FRun|P1|RN|AP|GC|UN|SD|OF)]>)

but I'm not even sure I'm going in the right direction.

[BrianHailey]

Perhaps something like THIS?

[jamesbarnett]

Thanks that works on + slopes, but not on -slopes. I'm just gonna keep using my two note styles and swapping the 2 back and forth.

[BrianHailey]

Instead of using the expression to return -1 and hiding the negative values, have it return 0 or .1" and then use it in the height of the text component.