0 Replies Latest reply: Jul 10, 2017 6:43 AM by Prathip Kumar RSS

    Set Analysis in Script

    Prathip Kumar

      Hi,

       

      Could you please help me , if there is a chance to write a set analysis expression in the load script.

       

      The set Analysis Expression will look like this

       

      =Num(if((count({<GENDER={'F'},[Candidate Status]={'Onboard'}>}CID)/count({<[Candidate Status]={'Onboard'}>}CID)> 0.445),

      if(count({<[level]={13}>}CID) >= 1 , ( 0.20*count({<[level]={13}>}CID) * 1),0) +

      if(count({<[level]={12}>}CID) >= 1 , ( 0.20*count({<[level]={12}>}CID) * 1),0) +

      if(count({<[level]={11}>}CID) >= 1 , ( 0.20*count({<[level]={11}>}CID) * 1.428),0) +

      if(count({<[ level]={10}>}CID) >= 1 , (0.20*count({<[ level]={10}>}CID) * 2),0) +

      if(count({<[ level]={9}>}CID) >= 1 , ( 0.20*count({<[level]={9}>}CID) * 3.33),0) +

      if(count({<[level]={8}>}CID) >= 1 , ( 0.20*count({<[ level]={8}>}CID) * 5),0)+

      if(count({<[level]={7}>}CID) >= 1 , ( 0.20*count({<[ level]={7}>}CID) * 10),0)+

      if(count({<[level]={6}>}CID) >= 1 , ( 0.20*count({<[level]={6}>}CID) * 10),0)

      ,

      0

      ),'##.0')

       

      Thanks,

      prathip