Calculating value after fractile

[Anonymous]

Hi

Here is my issue: I need to calculate value after fractile value.

Foe example for Category1 fractile value is 4.32 and value after it is 5, that is the one I would like to show to the user

This function does not work

=Min(If Value>Fractile(Value,0.83),Value)

Any suggestions?

Data:

LOAD * INLINE [

    Category, Value

    Category1, 1

    Category1, 2

    Category1, 3

    Category1, 4

    Category1, 5

    Category2, 1

    Category2, 1

    Category2, 3

    Category2, 4

    Category2, 11

];

[Chanty4u]

Fractile( aggr(avg(sales), somefield),0.83)

[Chanty4u]

=fractile(If([value]>( [value]),0.83)

[sunny_talwar]

May be this:

=Min(If(Value>Fractile(TOTAL Value,0.83),Value))

[Anonymous]

No, it does not work

=Min(If(Value>Fractile(TOTAL Value,0.83),Value))

this calculates it for all records

Fractile(TOTAL Value,0.83)

[sunny_talwar]

I am not sure what else you are looking for? Can you elaborate on the result you are looking for?

[swuehl]

Try

=Min(Aggr(If (Value>Fractile(TOTAL<Category> Value,0.83),Value),Category,Value))