Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
Thank you Jaime this is the solution i needed. 😁👍
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'
Jejejejeje there is the simple and elegant version of the answer 🙂