| Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
 Gold Customer
Joined: 3/22/2005
Posts: 11
|
I'm trying to create a % True that will show (H - L) => Maximum (H - L) for the last 105 days (Shift 5). I wrote this but it does not seem to work visually meet the criteria. (H-L) => (MAX105(H1-L1)).
Thank you.
BuyCycle
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
You need to actually expand out the formula:
H - L > H1 - L1 AND H - L > H2 - L2 AND H - L > H3 - L3 AND H - L > H4 - L4 AND H - L > H5 - L5 AND H - L > H6 - L6 AND H - L > H7 - L7 AND H - L > H8 - L8 AND H - L > H9 - L9 AND H - L > H10 - L10 AND H - L > H11 - L11 AND H - L > H12 - L12 AND H - L > H13 - L13 AND H - L > H14 - L14 AND H - L > H15 - L15 AND H - L > H16 - L16 AND H - L > H17 - L17 AND H - L > H18 - L18 AND H - L > H19 - L19 AND H - L > H20 - L20 AND H - L > H21 - L21 AND H - L > H22 - L22 AND H - L > H23 - L23 AND H - L > H24 - L24 AND H - L > H25 - L25 AND H - L > H26 - L26 AND H - L > H27 - L27 AND H - L > H28 - L28 AND H - L > H29 - L29 AND H - L > H30 - L30 AND H - L > H31 - L31 AND H - L > H32 - L32 AND H - L > H33 - L33 AND H - L > H34 - L34 AND H - L > H35 - L35 AND H - L > H36 - L36 AND H - L > H37 - L37 AND H - L > H38 - L38 AND H - L > H39 - L39 AND H - L > H40 - L40 AND H - L > H41 - L41 AND H - L > H42 - L42 AND H - L > H43 - L43 AND H - L > H44 - L44 AND H - L > H45 - L45 AND H - L > H46 - L46 AND H - L > H47 - L47 AND H - L > H48 - L48 AND H - L > H49 - L49 AND H - L > H50 - L50 AND H - L > H51 - L51 AND H - L > H52 - L52 AND H - L > H53 - L53 AND H - L > H54 - L54 AND H - L > H55 - L55 AND H - L > H56 - L56 AND H - L > H57 - L57 AND H - L > H58 - L58 AND H - L > H59 - L59 AND H - L > H60 - L60 AND H - L > H61 - L61 AND H - L > H62 - L62 AND H - L > H63 - L63 AND H - L > H64 - L64 AND H - L > H65 - L65 AND H - L > H66 - L66 AND H - L > H67 - L67 AND H - L > H68 - L68 AND H - L > H69 - L69 AND H - L > H70 - L70 AND H - L > H71 - L71 AND H - L > H72 - L72 AND H - L > H73 - L73 AND H - L > H74 - L74 AND H - L > H75 - L75 AND H - L > H76 - L76 AND H - L > H77 - L77 AND H - L > H78 - L78 AND H - L > H79 - L79 AND H - L > H80 - L80 AND H - L > H81 - L81 AND H - L > H82 - L82 AND H - L > H83 - L83 AND H - L > H84 - L84 AND H - L > H85 - L85 AND H - L > H86 - L86 AND H - L > H87 - L87 AND H - L > H88 - L88 AND H - L > H89 - L89 AND H - L > H90 - L90 AND H - L > H91 - L91 AND H - L > H92 - L92 AND H - L > H93 - L93 AND H - L > H94 - L94 AND H - L > H95 - L95 AND H - L > H96 - L96 AND H - L > H97 - L97 AND H - L > H98 - L98 AND H - L > H99 - L99 AND H - L > H100 - L100 AND H - L > H101 - L101 AND H - L > H102 - L102 AND H - L > H103 - L103 AND H - L > H104 - L104 AND H - L > H105 - L105
You may wish to review the following:
PCF Formula Descriptions
How to create a Personal Criteria Forumula (PCF)
Handy PCF example formulas to help you learn the syntax of PCFs!
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Gold Customer
Joined: 3/22/2005
Posts: 11
|
Thank you. I will give this a shot.
BuyCycle
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
You're welcome.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
|
Guest-1 |