Percentile calculation in SAC

[sanpe]

Dear experts,

is there a way to calculate percentile in SAC (either in a model or a story)? Analytic application is in this case not an option.

Thanks.

P.

[avsalynin]

sanpe

there are several ways:

• count in the calculated measure (measure 1/ measure 2; format - percentage);
• count through the context menu in the table - section "Add calculation" (percentage diff, percentage share);
• %GrandTotal function;

[sanpe]

Hi Aleksey,

The percentage is clear, I'm unable to replicate the statistical function percentile (the equivalent of excel function "Percentile.EXC")