How to Minimize the value in a line chart

[Anonymous]

Hi!

I have taken a line chart and took 2 different field Both are showing above one 200000. I need to minimize one field to less than 100000

How can i limit the value of a field

can u please help me

Thanks in advance.

[MarcoWedel]

Rangemin(Field,100000)

?

[schiappacasse]

If(Field>n , n , Field)

is this what you mean?