Aggr and Rank in Load Script

[Anonymous]

Hello everyone,

I have a problem where i need to convert these code into a readable code in the load script.

If( [Total Complaint Received] = 0, 1, Aggr(Rank(-Sum([Total Complaint Received]), 1,1), Factory) - 1)

As we all know, both Aggr and Rank function cannot use in the load script. Does anyone know how?

Thank you in advance!!!

[Anonymous · Accepted solution]

Based on information provided by Omar and Kevin,

I came out with a solution

newtable:

Load

[Factory],

    [Total Complaint Received],

    if([Total Complaint Received] = 0, 1,

    if([Total Complaint Received] = peek([Total Complaint Received]), peek(Rank), recno()-1)) as Rank

Resident maintable,

Order by [Total Complaint Received]

Thank everyone!!!

omarbensalem‌ ksomosera10‌

[ksomosera10]

Goood!

Glad to help!