FORMAT to increase column width and Nested IF
I Have two questions
1. I'm extracting data from BI to BPC with if condition as if material type = HAWA get one list, else if mattype = FERT get other list, else if anyone blank then add NONE
SALESMATRIX = *IF (0MATERIAL__0MATL_TYPE = *STR(HAWA) THEN 0CUSTOMER__0COUNTRY+0SALESEMPLY+ 0DISTR_CHAN; 0MATERIAL__0MATL_TYPE=*STR(FERT) THEN 0CUSTOMER__0COUNTRY+0SALESEMPLY+ 0DISTR_CHAN; 0SALESEMPLY=*STR() THEN *STR(NONE); 0DISTR_CHAN=*STR() THEN *STR(NONE))
is this formula correct, because my package get failed by giving blank member to SALESMATRIX.
Can anyone please let me know how can I write IF...ELSE statements in Transformation file.
2. I'm trying to increase column width for my LOCAL Member Formula, but after refreshing again it is not increasing and value not able to see, it will be in #####.
Can anyone please let me know how can I increase my column width for total