Support Board
Date/Time: Tue, 14 Jan 2025 11:37:07 +0000
Post From: NON-ZERO MEDIAN
| [2017-05-03 18:51:52] |
| User98657 - Posts: 329 |
|
I'd like to know if there's some way to get a median value for a zig zag study on a spreadsheet. There isn't a "MEDIAN_IGNORZEROS" function, so I'm wondering if there's a work around. The "MEDIAN" function applied to the entire column of ZigZag study values includes more zeros than any other number so you're median value is zero unless there's a way to avoid including the zeros. |