11 Replies Latest reply: Sep 5, 2018 12:19 AM by Kevin Somosera RSS

    Aggr and Rank in Load Script

    Muhammad Hazim Muhammad Alif

      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!!!