Support Board

Date/Time: Mon, 16 Sep 2024 19:58:58 +0000

Post From: NON-ZERO MEDIAN

[2017-05-03 18:51:52] Link To Thread - Link To Post [Go To First Post]
User98657 - Posts: 322
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.