Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

FORMAT to increase column width and Nested IF

Hi

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

Regards

Silu

Former Member

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question