jamovi icon indicating copy to clipboard operation
jamovi copied to clipboard

Percentiles calculation

Open dmirkov opened this issue 4 months ago • 6 comments

Hi,

When trying to calculate the percentiles (percentrank) in additional column (Windows) on 2.7.14.0 i get blank column, while doing the same on Mac or in 2.6.44.0 it works and shows the calculated output. What I am doing wrong?

Image Image

dmirkov avatar Dec 13 '25 17:12 dmirkov

not sure what's going on here. works fine for me. you could save a .omv file, zip it up, and attach it to this issue, and i'll see if there's any additional clues in the data file.

cheers

jonathon-love avatar Dec 14 '25 02:12 jonathon-love

Here are both files: the one that works and the one without result. The same data set was loaded (xlsx file).

Table_2_1.zip

dmirkov avatar Dec 14 '25 07:12 dmirkov

what happens if you use the formulas RANK(X) and VROWS(X) by themselves? do both of them produce results?

jonathon-love avatar Dec 15 '25 08:12 jonathon-love

RANK works, VROWS don't...

Dragan Mirkov | CSO @ Onescrin [photo-logo]http://onescrin.com/ E. @.@.> W. onescrin.comhttp://onescrin.com/ M. +381 64 612 9779 [linkedin]https://www.linkedin.com/in/draganmirkov/ [instagram]https://www.instagram.com/onescrin_/ [facebook]https://www.facebook.com/onescrin1 [twitter_x]https://x.com/onescrin_

From: Jonathon Love @.> Sent: Monday, December 15, 2025 9:46 AM To: jamovi/jamovi @.> Cc: dmirkov @.>; Author @.> Subject: Re: [jamovi/jamovi] Percentiles calculation (Issue #1750)

[https://avatars.githubusercontent.com/u/3240247?s=20&v=4]jonathon-love left a comment (jamovi/jamovi#1750)https://github.com/jamovi/jamovi/issues/1750#issuecomment-3654462549

what happens if you use the formulas RANK(X) and VROWS(X) by themselves? do both of them produce results?

Reply to this email directly, view it on GitHubhttps://github.com/jamovi/jamovi/issues/1750#issuecomment-3654462549, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AO2A5JGEPANUSZN6DAL2IE34BZYM3AVCNFSM6AAAAACO6H5CKSVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZTMNJUGQ3DENJUHE. You are receiving this because you authored the thread.Message ID: @.@.>>

dmirkov avatar Dec 15 '25 09:12 dmirkov

RANK works, VROWS don't...

dmirkov avatar Dec 16 '25 19:12 dmirkov

kinda weird. in place of VROWS(), what if you use VMAX(ROW()) ?

jonathon-love avatar Dec 16 '25 23:12 jonathon-love