Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi Paul,
May be something like this..
If( ([Reporting Code]>=50010 and [Reporting Code]<=50090) or
([Reporting Code]>=20005 and [Reporting Code]<=20063),
'tOTAL_ASSET') as [tOTAL_ASSET]
OR
if you want the fIXED ASSET and cURR ASSET value in your tOTAL ASSET field, try something like..
If([Reporting Code]>=50010 and [Reporting Code]<=50090,'cURR_ASSET',
If([Reporting Code]>=20005 and [Reporting Code]<=20063,'fIXED_ASSET'))as [tOTAL_ASSET]
Hi Paul,
May be something like this..
If( ([Reporting Code]>=50010 and [Reporting Code]<=50090) or
([Reporting Code]>=20005 and [Reporting Code]<=20063),
'tOTAL_ASSET') as [tOTAL_ASSET]
OR
if you want the fIXED ASSET and cURR ASSET value in your tOTAL ASSET field, try something like..
If([Reporting Code]>=50010 and [Reporting Code]<=50090,'cURR_ASSET',
If([Reporting Code]>=20005 and [Reporting Code]<=20063,'fIXED_ASSET'))as [tOTAL_ASSET]
Hi Settu
Many thank it work fine.
Paul
Hi Settu
this is one of the script you give me :-
If([Reporting Code]>=50010 and [Reporting Code]<=50090,'cURR_ASSET',
If([Reporting Code]>=20005 and [Reporting Code]<=20063,'fIXED_ASSET'))as
[tOTAL_ASSET]
I am getting null value.
Paul
Hi Paul,
Can you check the 'Report Code' value is available (between 50010 and 50090) ? and is that created the new field 'tOTAL ASSET' ?