1 Reply Latest reply: Aug 26, 2016 9:20 AM by Onno van Knotsenburg RSS

    Dollar Range in load scipt-Bucket

    John Hamulak

      I have not done this before but I was curious about using dollar ranges in the load script. Has anyone done anything like this?

       

      Load

        IF (plan_pd_amt>0 and plan_pd_amt <5000, '<5000',

        IF(plan_pd_amt>= 5000 and plan_pd_amt<= 10000, '5000-10000',

        IF(plan_pd_amt> 10000 and plan_pd_amt<= 15000, '10000-15000',

        IF(plan_pd_amt>=15000 and plan_pd_amt<= 20000, '15000-20000',

        IF(plan_pd_amt> 20000 and plan_pd_amt<= 25000, '20000-25000',

        IF(plan_pd_amt>25000 and plan_pd_amt<= 30000, '25000-30000',

        IF(plan_pd_amt>30000 and plan_pd_amt<= 35000, '30000-35000',

        IF(plan_pd_amt> 35000 and plan_pd_amt< =40000,'35000 - 45000',

        IF(plan_pd_amt> 50000,'50000+'))))))))  as  PaidRange