Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!!!
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!!!
Goood!
Glad to help!