Hi
I'm trying to create some formulas on my data table using the proceeding load but it doesn't seem to work - help? Suggestions
DATA2:
Load
*,
[Title_UK],
IF(ISNULL([Title_UK]) OR LEN(trim([Title_UK] ))=0 OR [Title_UK] =0, Title_US,
IF(ISNULL([Title_US]) OR LEN(trim([Title_US]))=0 OR [Title_US]=0, Title_FR,
IF(ISNULL([Title_FR]) OR LEN(trim([Title_FR]))=0 OR [Title_FR]=0, Title_ESP,
IF(ISNULL([Title_ESP]) OR LEN(trim([Title_ESP]))=0 OR [Title_ESP]=0, Title_NZ,
IF(ISNULL([Title_NZ]) OR LEN(trim([Title_NZ]))=0 OR [Title_NZ]=0, Title_GER,
IF(ISNULL([Title_GER]) OR LEN(trim([Title_GER]))=0 OR [Title_GER]=0, Title_ITA,
IF(ISNULL([Title_ITA]) OR LEN(trim([Title_ITA]))=0 OR [Title_ITA]=0, Title_AUS))))))) AS "Title_Filter",
[Release_Date_UK],
IF(ISNULL([Release_Date_UK]) OR LEN(trim([Release_Date_UK] ))=0 OR [Release_Date_UK] =0, Release_Date_US,
IF(ISNULL([Release_Date_US]) OR LEN(trim([Release_Date_US]))=0 OR [Release_Date_US]=0, Release_Date_FR,
IF(ISNULL([Release_Date_FR]) OR LEN(trim([Release_Date_FR]))=0 OR [Release_Date_FR]=0, Release_Date_ESP,
IF(ISNULL([Release_Date_ESP]) OR LEN(trim([Release_Date_ESP]))=0 OR [Release_Date_ESP]=0, Release_Date_NZ,
IF(ISNULL([Release_Date_NZ]) OR LEN(trim([Release_Date_NZ]))=0 OR [Release_Date_NZ]=0, Release_Date_GER,
IF(ISNULL([Release_Date_GER]) OR LEN(trim([Release_Date_GER]))=0 OR [Release_Date_GER]=0, Release_Date_ITA,
IF(ISNULL([Release_Date_ITA]) OR LEN(trim([Release_Date_ITA]))=0 OR [Release_Date_ITA]=0, Release_Date_AUS))))))) AS "Release Date_Filter",
[WW_IBOE],
IF(ISNULL([WW_IBOE]) OR LEN(trim([WW_IBOE] ))=0 OR [WW_IBOE] =0, IBOE_UK,
IF(ISNULL([IBOE_UK]) OR LEN(trim([IBOE_UK] ))=0 OR [IBOE_UK] =0, IBOE_US,
IF(ISNULL([IBOE_US]) OR LEN(trim([IBOE_US]))=0 OR [IBOE_US]=0, IBOE_FR,
IF(ISNULL([IBOE_FR]) OR LEN(trim([IBOE_FR]))=0 OR [IBOE_FR]=0, IBOE_GER,
IF(ISNULL([IBOE_GER]) OR LEN(trim([IBOE_GER]))=0 OR [IBOE_GER]=0, IBOE_ITA ))))) AS "IBOE_Filter"
;
Load
*,
//SUM (Count(( "US_Cume Gross $") )) AS "total US Cume",
num(Sum("UK_Cume Gross $") + Sum("WW_International Cume Gross")) as "$_WW",
num(SUM ("UK_Cume Gross $") + SUM ("FR_Cume Adm") + SUM ( "GER_Cume Adm") + SUM ("NZ_Cume Gross $") + SUM ( "AUS_Cume Gross $")) AS "$ SC Total"
;
Load
[Title_UK], Title_US, Title_FR, Title_ESP, Title_NZ, Title_GER, Title_ITA, Title_AUS,
"Booking_Number" ,
[Release_Date_UK], Release_Date_US, Release_Date_FR, Release_Date_ESP, Release_Date_NZ, Release_Date_GER, Release_Date_ITA, Release_Date_AUS,
//"Release Date" ,
"$ Budget",
//"$_WW",
//[$ INT],
"WW_International Cume Gross",
//"$ SC Total",
"UK_Cume Gross $" ,
"US_Cume Gross $" ,
"FR_Cume Adm" ,
"GER_Cume Adm",
[WW_IBOE],[IBOE_UK], IBOE_US, IBOE_FR, IBOE_GER, IBOE_ITA,
"$ GER",
"ITA_Cume Adm",
"$ ITA",
"$_ESP",
//"ESP_Cume Gross $" ,
"AUS_Cume Gross $" ,
"NZ_Cume Gross $"
Resident DATA;
Drop table DATA;
