Forum Discussion

ChristianDGreat's avatar
ChristianDGreat
Resolver I
3 years ago
Solved

Complex Scoring

Hi everyone, I was thinking on solving this but I got stuck to the last part. So imagine you have this kind of table   Order Number Order Number Line Status Date Qty AAA AA1 Booked ...
Need Help
  • lbendlin's avatar
    lbendlin
    3 years ago

    The score makes no sense as the quantity for AA2 is not the same (4 vs 2) so the top score should be 0.

     

     

     

     

    See attached for the proposed implementation.

     

     

lbendlin's avatar
lbendlin
Super User
3 years ago

The score makes no sense as the quantity for AA2 is not the same (4 vs 2) so the top score should be 0.

 

 

 

 

See attached for the proposed implementation.

 

 

  • ChristianDGreat's avatar
    ChristianDGreat
    Resolver I
    3 years ago

    Thanks for this but I figure it out.
    Its using INSCOPE formula,

    IF INSCOPE of the ORDER NUMBER compute with the Total, and if its in ORDER ITEM LINE it will compute by Order Item Line.

     

    Thanks!