if( ( sum({=$(vCurrentYear)00<=$(vCurrentPeriod)"}>}1 * _Date_Extra_CY_Flag) > 0 or sum({}1 * _Date_Extra_FY_Flag) > 0 or sum({=$(vCurrentYear)00<=$(vCurrentYear)12"}>}1 * _Date_Extra_Q_Flag) > 0 ) and (sum({=$(vPreviousYear)12<=$(vCurrentYear)12"}>}1) > 0 or Match(only({}KPI), 'A', 'B', 'C')) , Pick(Match(only({}KPI), 'A', 'B', 'C', 'D', 'E', 'F', 'G', 'H', 'I', 'J', 'K', 'L', 'M', 'N', 'O', 'P', 'Q', 'R', 'S', 'T', 'U', 'V', 'W', 'X', 'Y', 'Z') , if(Act >= -0.05 and Act <= 0.05 , GREEN(), RED()) //A , if(Act >= -0.05 and Act <= 0.05 , GREEN(), RED()) //B , if(Act >= -0.05 and Act <= 0.05 , GREEN(), RED()) //C , if(Act-TGT >= 0, GREEN(), RED()) //D , if(Act-TGT >= 0, GREEN(), RED()) //E , if(Act-TGT >= 0, GREEN(), RED()) //F , if(Act-TGT >= 0, GREEN(), RED()) //G , if(Act-TGT <= 0, GREEN(), RED()) //H , if(Act-TGT <= 0, GREEN(), RED()) //I , if(Act-TGT <= 0, GREEN(), RED()) //J , if(Act-TGT >= 0, GREEN(), RED()) //K , if(Act-TGT >= 0, GREEN(), RED()) //L , if(Act-TGT >= 0, GREEN(), RED()) //M , if(Act-TGT <= 0, GREEN(), RED()) //N , if(Act-TGT <= 0, GREEN(), RED()) //O , if(Act-TGT >= 0, GREEN(), RED()) //P , if(Act-TGT >= 0, GREEN(), RED()) //Q , if(Act-TGT >= 0, GREEN(), RED()) //R , if(Act-TGT <= 0, GREEN(), RED()) //S , if(Act-TGT <= 0, GREEN(), RED()) //T , if(Act-TGT >= 0, GREEN(), RED()) //U , if(Act-TGT >= 0, GREEN(), RED()) //V , if(Act-TGT <= 0, GREEN(), RED()) //W , if(Act-TGT >= 0, GREEN(), RED()) //X , if(Act-TGT <= 0, GREEN(), RED()) //Y , if(Act-TGT <= 0, GREEN(), RED()) //Z ) , White() )