Skip to Content
avatar image
Former Member

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Dec 29, 2014 at 09:41 AM

    Hi Silu,

    For the first question - start with simple *IF and continue...

    For the second - if you have enabled "Auto Fit Column Width" in Sheet Options - then your local members will fit!

    Vadim

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 29, 2014 at 09:26 AM

    Hi

    to add one more point for Transformation file formula

    if Profit Center = CCP then irrespective of material type get one value

    if profit center <> CCP and mattype = HAWA then bring one value from BI

    if Proft center <> CCP and mattype <> HAWA then bring another value from BI

    so how can I go ahead for this IF condition in transformation file

    Regards

    Silu

    Add comment
    10|10000 characters needed characters exceeded