4 Replies Latest reply: Jun 6, 2016 12:18 AM by Settu Periyasamy RSS

    How to combine 2 load script into 1 for compute total asset ?

    PAUL YEO

      Hi All

       

      I have below 2 load script working fine :-

       

      If([Reporting Code]>=50010 and [Reporting Code]<=50090,'cURR_ASSET') as [cURR_ASSET],

      If([Reporting Code]>=20005 and [Reporting Code]<=20063,'fIXED_ASSET') as [fIXED_ASSET],

       

      I try to combine the above 2 into 1 load script , i try below :-

       

      If([Reporting Code]>=50010 and [Reporting Code]<=50090,'cURR_ASSET',

      If([Reporting Code]>=20005 and [Reporting Code]<=20063,'fIXED_ASSET',

      ))as [tOTAL_ASSET]

       

      it return wrong value. Can some one advise me ?

       

      it should be look some thing like below :-

       

      If([Reporting Code]>=50010 and [Reporting Code]<=50090) & ([Reporting Code]>=20005 and [Reporting Code]<=20063,'tOTAL_ASSET') as [tOTAL_ASSET],

       

      Paul