How can I create a PCF that could do that following:

1) Count the number of down days over the past 15 days. Down is defined as C<C1

2) Divide the number of down days by the total number, in this case 15.

Any help much appreciated and happy Memorial Day!

Please try the following Indicator Formula:

ABS((C < C1) + (C1 < C2) + (C2 < C3) + (C3 < C4) + (C4 < C5) + (C5 < C6) + (C6 < C7) + (C7 < C8) + (C8 < C9) + (C9 < C10) + (C10 < C11) + (C11 < C12) + (C12 < C13) + (C13 < C14) + (C14 < C15)) / 15

It should be noted that if you multiplied the above by 100, it would be the same as creating a Custom PCF % True Indicator with the following settings:

- Period: 15
- Average Type: Simple
- Boolean Formula: C < C1

PCF Formula Descriptions
Handy PCF example formulas to help you learn the syntax of PCFs!