x Want to participate? Join the group to interact
  • State Not Answered
  • Replies 4 replies
  • Subscribers 29 subscribers
  • Views 1068 views
  • Users 0 members are here
Browse Forums
Announcements
322
topics
19
replies
General Discussion
82
topics
183
replies
sue healey

x3 export template-using list in parameters using a global variable - selection criteria

Posted By

Hi in the criteria screen during an export can I use a global variable / against a parameter to select a list of companies - if so how do I do the list of companies and what do I put in the selection criteria- have tried lots of options - such as comma seperate list in the parameter then find([F:BAL]CPY,GZCOMP) - comes back with 0 records if I put [F:BAL]CPY='185' | [F:BAL]CPY='195'     etc.  this works but not enought room for my list (also tried using company groups - this also doesn't work) 

Parents Reply Children
  • 0 in reply to Mike Shaw

    Hi Sue,

    I've done some investigating, and I think you might need to use "Instr" rather than "find".

    So, I've created a new Parameter called ZSITELIST in SUP > TRI just for fun and put the value 

    'GB001','GB011','GB012'

    Then, in Calculator Wizard, I used AFNC.PARAMDOS to access a Folder-level Parameter value -  I've put

    instr(0,func AFNC.PARAMDOS("SEED","ZSITELIST"),"GB011")

    This will produce the result "10".

    instr(0,func AFNC.PARAMDOS("SEED","ZSITELIST"),"GB001")  results in 2

    instr(0,func AFNC.PARAMDOS("SEED","ZSITELIST"),"GB010")  results in 0

    instr(0,func AFNC.PARAMDOS("SEED","ZSITELIST"),"GB012")  results in 18

     

    I hope this works for you.

  • 0 in reply to Richard Perrins

    thats great I will have a go

    much appreciated sue

  • 0 in reply to sue healey

    Hi Sue, pleased to see Richard posted a solution for you, if you found it helpful, I wondered if you could click More > Verify Answer on his reply, that helps us to flag verified answers to other community memebrs, many thanks.

    Andy
    Sage UKI

*Community Hub is the new name for Sage City