Chart value cut (1 Viewer)

georg7

Registered User.
Local time
Yesterday, 16:25
Joined
Sep 3, 2019
Messages
33
Hi there,
I have a problem with my Chart. Sometimes the value is to big and my line goes out of the Chart. Does somebody know how to cut my value if ist bigger than 1,5?
So if it's 1,6 it will be cut to 1,5.
In Excel it's
(X1 > 1,5;1,5;X1)

Best regards
Georg
 

Attachments

CJ_London

Super Moderator
Staff member
Local time
Today, 00:25
Joined
Feb 19, 2013
Messages
12,092
similar in access, use the iif function

iif(X1 > 1,5,1.5,X1)

replace X1 with the name of your field
 

georg7

Registered User.
Local time
Yesterday, 16:25
Joined
Sep 3, 2019
Messages
33
It worked Pretty well! Thank you CJ_London
Have a good one
 

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

Top Bottom