Graphics

 View Only
  • 1.  Comparing integer

    Posted 11-03-2019 09:23

    hello Experts as you can see in image , i want to compare pts field and arrange all group in descending order. but if pts field is equal then i want to compare net rr field to set descending order. i use visual logic to compare pts and make it descending order but after that if pts field is equal then i cannot set comparing Net rr. 

    file link is below

    https://drive.google.com/open?id=1blz0NSUPscofeY4Ov7kqCjcceQ1kumox

     

    any help in visual logic. file is attached. 

     

    thank you



  • 2.  RE: Comparing integer

    Posted 11-04-2019 19:15

    Hello Sunil,

    if "Net rr" values are between -X/2 and X/2 , you can use  ("Pts Fields" * X + "Net rr" ) as computed values to sort.

    Here is an example with X=10 , visual logic looks like this :

    this should work,

    regards,

    Antoine


    #XPression


  • 3.  RE: Comparing integer

    Posted 11-04-2019 19:58

    Thank youmignon . Yeap it will work . I had tried only adding ptsand net rr field so i got some mistake but multiplyibg by 10 it will help. Thank you again


    #XPression