Forum Discussion

ChristianDGreat's avatar
ChristianDGreat
Icon for Resolver I rankResolver 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
Icon for Super User rankSuper 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
Icon for Resolver I rankResolver 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!