/*This works by itself*/ sum( pick( match(short_modality, 'AX' ,'CR' ,'MI' ,'MR' ,'SY' ,'US' ,'XP' ) ,if(len(trim([v_AX]))=0,orig_rate_used,[v_AX])*revenue_per_day*Forecast_days ,if(len(trim([v_CR]))=0,orig_rate_used,[v_CR])*revenue_per_day*Forecast_days ,if(len(trim([v_MI]))=0,orig_rate_used,[v_MI])*revenue_per_day*Forecast_days ,if(len(trim([v_MR]))=0,orig_rate_used,[v_MR])*revenue_per_day*Forecast_days ,if(len(trim([v_SY]))=0,orig_rate_used,[v_SY])*revenue_per_day*Forecast_days ,if(len(trim([v_US]))=0,orig_rate_used,[v_US])*revenue_per_day*Forecast_days ,if(len(trim([v_XP]))=0,orig_rate_used,[v_XP])*revenue_per_day*Forecast_days ) ) /*And this works by itself*/ sum( pick( match(modality ,'AX AXA' ,'AX ECS' ,'CR CT' ,'CR RO' ,'MI PCL' ,'MI PET' ,'MI SPECT' ,'MR' ,'SY VIA' ,'US' ,'XP RF' ,'XP SU' ,'XP UR' ,'XP WH' ) ,if(len(trim([v_AX AXA]))=0,orig_rate_used,[v_AX AXA])*revenue_per_day*Forecast_days ,if(len(trim([v_AX ECS]))=0,orig_rate_used,[v_AX ECS])*revenue_per_day*Forecast_days ,if(len(trim([v_CR CT]))=0,orig_rate_used,[v_CR CT])*revenue_per_day*Forecast_days ,if(len(trim([v_CR RO]))=0,orig_rate_used,[v_CR RO])*revenue_per_day*Forecast_days ,if(len(trim([v_MI PCL]))=0,orig_rate_used,[v_MI PCL])*revenue_per_day*Forecast_days ,if(len(trim([v_MI PET]))=0,orig_rate_used,[v_MI PET])*revenue_per_day*Forecast_days ,if(len(trim([v_MI SPECT]))=0,orig_rate_used,[v_MI SPECT])*revenue_per_day*Forecast_days ,if(len(trim([v_MR]))=0,orig_rate_used,[v_MR])*revenue_per_day*Forecast_days ,if(len(trim([v_SY VIA]))=0,orig_rate_used,[v_SY VIA])*revenue_per_day*Forecast_days ,if(len(trim([v_US]))=0,orig_rate_used,[v_US])*revenue_per_day*Forecast_days ,if(len(trim([v_XP RF]))=0,orig_rate_used,[v_XP RF])*revenue_per_day*Forecast_days ,if(len(trim([v_XP SU]))=0,orig_rate_used,[v_XP SU])*revenue_per_day*Forecast_days ,if(len(trim([v_XP UR]))=0,orig_rate_used,[v_XP UR])*revenue_per_day*Forecast_days ,if(len(trim([v_XP WH]))=0,orig_rate_used,[v_XP WH])*revenue_per_day*Forecast_days ) ) /*But I cannot blend the two*/ sum( pick( match(short_modality, 'AX' ,'CR' ,'MI' ,'MR' ,'SY' ,'US' ,'XP' ) match(modality ,'AX AXA' ,'AX ECS' ,'CR CT' ,'CR RO' ,'MI PCL' ,'MI PET' ,'MI SPECT' ,'MR' ,'SY VIA' ,'US' ,'XP RF' ,'XP SU' ,'XP UR' ,'XP WH' ) + 7 ,if(len(trim([v_AX]))=0,orig_rate_used,[v_AX])*revenue_per_day*Forecast_days ,if(len(trim([v_CR]))=0,orig_rate_used,[v_CR])*revenue_per_day*Forecast_days ,if(len(trim([v_MI]))=0,orig_rate_used,[v_MI])*revenue_per_day*Forecast_days ,if(len(trim([v_MR]))=0,orig_rate_used,[v_MR])*revenue_per_day*Forecast_days ,if(len(trim([v_SY]))=0,orig_rate_used,[v_SY])*revenue_per_day*Forecast_days ,if(len(trim([v_US]))=0,orig_rate_used,[v_US])*revenue_per_day*Forecast_days ,if(len(trim([v_XP]))=0,orig_rate_used,[v_XP])*revenue_per_day*Forecast_days ,if(len(trim([v_AX AXA]))=0,orig_rate_used,[v_AX AXA])*revenue_per_day*Forecast_days ,if(len(trim([v_AX ECS]))=0,orig_rate_used,[v_AX ECS])*revenue_per_day*Forecast_days ,if(len(trim([v_CR CT]))=0,orig_rate_used,[v_CR CT])*revenue_per_day*Forecast_days ,if(len(trim([v_CR RO]))=0,orig_rate_used,[v_CR RO])*revenue_per_day*Forecast_days ,if(len(trim([v_MI PCL]))=0,orig_rate_used,[v_MI PCL])*revenue_per_day*Forecast_days ,if(len(trim([v_MI PET]))=0,orig_rate_used,[v_MI PET])*revenue_per_day*Forecast_days ,if(len(trim([v_MI SPECT]))=0,orig_rate_used,[v_MI SPECT])*revenue_per_day*Forecast_days ,if(len(trim([v_MR]))=0,orig_rate_used,[v_MR])*revenue_per_day*Forecast_days ,if(len(trim([v_SY VIA]))=0,orig_rate_used,[v_SY VIA])*revenue_per_day*Forecast_days ,if(len(trim([v_US]))=0,orig_rate_used,[v_US])*revenue_per_day*Forecast_days ,if(len(trim([v_XP RF]))=0,orig_rate_used,[v_XP RF])*revenue_per_day*Forecast_days ,if(len(trim([v_XP SU]))=0,orig_rate_used,[v_XP SU])*revenue_per_day*Forecast_days ,if(len(trim([v_XP UR]))=0,orig_rate_used,[v_XP UR])*revenue_per_day*Forecast_days ,if(len(trim([v_XP WH]))=0,orig_rate_used,[v_XP WH])*revenue_per_day*Forecast_days ) )