Make text on data points invisible

[guyvermeiren]

Hello,

I have a linechart where I want to make the text on a conditonal number of datapoints invisble.

For the line I already did this by using conditional "Background Color" by using (see also example)

=

if(Num(COPA.Period)<=Num(Month(Today()))-1,Black(255),White())

Can I do the same for making the text on the datapoints disappear ??

Thanks.

Best regards,

Guy

[prieper]

If you open the "+" below the expression, there is a field called "Show Value", where you may enter a condition.

HTH
Peter

[guyvermeiren]

Thanks Peter,

Can you give me an idea of what type of condition I have to use ??

Best regards,

Guy

[prieper]

Which entries do you wish to maintain? Can you post an example?

Peter

[guyvermeiren]

Thanks Peter,

I already solved the problem in this way:

I used "Text Color" with condition: =if(Num(COPA.Period)<=Num(Month(Today()))-1,Black(255),White())

In this way I only get (see) the result for the "Months" (number) lower than today.

Best regards,

Guy

[guyvermeiren]

Help,

There are strange things happening. Yesterday it worked as I said in my former message. Today still no result.

However, if I make the choice "Text on Axis" all the formats work. I can make the text any color or invisible by using the condition

=if(Num(COPA.Period)<=Num(Month(Today()))-1,black(255),white(255)) for "Text Color"

Why doesn't this work for the option "Text on Datapoint" ?? Is there a bug in version 9.00 SR3 or 4 ??

Thanks,

Guy