Level 3 sprint 1

andis
Contributor

Level 3 sprint 1

Hi Experts,

A couple of weeks ago, I imported data into the below module.

andis_0-1615443797141.png

 

Then, I summarized the above data into the below module.

andis_1-1615443845682.png

 

I have no clue to get data PY Country and Product Family Sales in the below module.

andis_2-1615443937004.png

 

Please advise me.

 

Regards,

23 REPLIES 23
ssicefox
Frequent Contributor

@SuhasDesai 

You lost " ELSE".

ssicefox
Frequent Contributor

@SuhasDesai 

 

IF THEN ELSE

Misbah
Moderator

@SuhasDesai 

 

There is no ELSE statement.

 

I could see

IF xxxx THEN yyyy 

it needs to be 

IF xxxx THEN yyyy  ELSE zzzz

 

Misbah

ssicefox
Frequent Contributor

Hi @Misbah , 

 

@JaredDolich 

How are you?

I am trying to upload the CYW Scenario Territory to Accounts.CSV into the Territory>Account# List, but I did find a solution to concatenate Territory code and Account code for filling the Code column.

 

ssicefox_0-1631610027609.png

 

Any hint/clue is much Appreciated.

 

Thanks in advance!

 

I am looking forward to hearing from you soon. Best regards.

 

Wei