Alteryx summarize tool median gives wrong number

[Alder]

I have discovered this bug while at work and I'm not allowed to upload anything from my work PC.

median gives wrong number when nulls are involved (or maybe more)

I had large dataset at work with 100,000 records, a bunch of dates (date) and a numeric field (percentage)

when validating the results of the summarize tool (group by date, median percentage) I saw that it gives the wrong number for many of the dates

upon further investigation this seems to happen on my older version of alteryx but still why wud this happen?

[cjaneczko]

I have tested the above as well and get the desired results. You should look into upgrading the versions. This could have been a bug in the past that was patched. 

[Alder]

I tested it with and without AMP first thing at work today. 

AMP off = correct result

AMP on = wrong result

mine is version 2022.1.1.40869

the colleagues with an older version like mine have the same result as I do.

the colleagues with a newer version have correct results with both AMP on and off

finally found the culprit

thanks people