having trouble on selecting top 10 customer via button

[Irvin182]

Hi I need help, I'm working on button top 10 customers that will select in field Customer_No that's arrange in order descending [Total Scores] and descending [Total MSF].

the problem is I don't have any basis to get the total score and total msf to select the customer.

Thanks,

Irvin

[jaibau1993 · Accepted solution]

Hi!

Beautiful problem 😁.

Try the following in "jaibau expression"

Rank(
MAX(ComplaitScore)+MAX(ContractScore)+MAX(FaultScore)+max(SalesIncident)
+
1/(
Rank(Sum({<CustomerID = {"=Rank(MAX(ComplaitScore)+MAX(ContractScore)+MAX(FaultScore)+max(SalesIncident),1) <= 10"}>} MSF_PHP)) + 1
)
,1) <= $(vTopCust)

Output:

Greetings,

Jaime.

[Irvin182]

Thank you Jaime this is the solution i needed.  😁👍

[tresesco]

Or, you can use two simpler triggers (search strings) as:

Trigger 1:  ='=Rank(MAX(ComplaitScore)+ max(ContractScore) +Max(SalesIncident) + max(FaultScore))<=10'

Trigger 2:  ='=Rank(sum(MSF))<=10'

[jaibau1993]

Jejejejeje there is the simple and elegant version of the answer 🙂