Automate

Hi,

I have a scenario where I have a variable number of capacities in a work center (usually 1 or 2). I need to update the Control CapacityReduction fields. I would like to do a download of the field to see make sure it exists, if it does, then do an update. When I download the field the list is numbered 0-3. Excel does not show the 0, it leaves the cell blank. Any idea how to force it to populate with a 0 when that's the selection from the list? Any time it is already set to Formula-related I can't get it to update.



------------------------------
Derek Sayres | SAP PLM Business Analyst
------------------------------

This sounds too simple to be the issue but have you checked to make sure that the Display options in this worksheet section of the Advanced Options has the "Show a zero in cells that have a Zero Value" box checked?


------------------------------
Greg Papendick | Director - Master Data
Dairy Farmers of America, Inc. | (816) 801-6458
------------------------------

Original Message:
Sent: 09-04-2019 17:29
From: Derek Sayres
Subject: excel download 0 as blank value - want to see 0

Hi,

I have a scenario where I have a variable number of capacities in a work center (usually 1 or 2). I need to update the Control CapacityReduction fields. I would like to do a download of the field to see make sure it exists, if it does, then do an update. When I download the field the list is numbered 0-3. Excel does not show the 0, it leaves the cell blank. Any idea how to force it to populate with a 0 when that's the selection from the list? Any time it is already set to Formula-related I can't get it to update.

If someone know how to force the 0 to show up or another method I would love some assistance.

I could do two separate scripts, one for one capacity, one for two, but I'd like to try to keep it to one script for the end users.

Thanks,

Derek

------------------------------
Derek Sayres | SAP PLM Business Analyst
------------------------------

Hi Greg, thanks for the reply.

That box is checked. There's padding in SAP to help, I am not allowed to do a transform since it's the downloaded cell where I want 0 to display.

------------------------------
Derek Sayres | SAP PLM Business Analyst
------------------------------

Original Message:
Sent: 09-05-2019 08:58
From: Greg Papendick
Subject: excel download 0 as blank value - want to see 0

This sounds too simple to be the issue but have you checked to make sure that the Display options in this worksheet section of the Advanced Options has the "Show a zero in cells that have a Zero Value" box checked?


------------------------------
Greg Papendick | Director - Master Data
Dairy Farmers of America, Inc. | (816) 801-6458

Original Message:
Sent: 09-04-2019 17:29
From: Derek Sayres
Subject: excel download 0 as blank value - want to see 0

Hi,

I have a scenario where I have a variable number of capacities in a work center (usually 1 or 2). I need to update the Control CapacityReduction fields. I would like to do a download of the field to see make sure it exists, if it does, then do an update. When I download the field the list is numbered 0-3. Excel does not show the 0, it leaves the cell blank. Any idea how to force it to populate with a 0 when that's the selection from the list? Any time it is already set to Formula-related I can't get it to update.

If someone know how to force the 0 to show up or another method I would love some assistance.

I could do two separate scripts, one for one capacity, one for two, but I'd like to try to keep it to one script for the end users.

Thanks,

Derek

------------------------------
Derek Sayres | SAP PLM Business Analyst
------------------------------

You may want to try padding with zero's since that may make it look like a text field to Excel.   or Post-Pad with spaces to see if it might do the same thing.  I have never encountered this with any of the field downloads that I have executed.  I have had issues with blanks appearing as zero's for number fields but that has never been a problem in my scripts.  

If that does not work it may be time to submit a support ticket.  I have always had excellent service from the support team.

------------------------------
Greg Papendick | Director - Master Data
Dairy Farmers of America, Inc. | (816) 801-6458
------------------------------

Original Message:
Sent: 09-05-2019 09:58
From: Derek Sayres
Subject: excel download 0 as blank value - want to see 0

Hi Greg, thanks for the reply.

That box is checked. There's padding in SAP to help, I am not allowed to do a transform since it's the downloaded cell where I want 0 to display.

------------------------------
Derek Sayres | SAP PLM Business Analyst

Original Message:
Sent: 09-05-2019 08:58
From: Greg Papendick
Subject: excel download 0 as blank value - want to see 0

This sounds too simple to be the issue but have you checked to make sure that the Display options in this worksheet section of the Advanced Options has the "Show a zero in cells that have a Zero Value" box checked?


------------------------------
Greg Papendick | Director - Master Data
Dairy Farmers of America, Inc. | (816) 801-6458

Original Message:
Sent: 09-04-2019 17:29
From: Derek Sayres
Subject: excel download 0 as blank value - want to see 0

Hi,

I have a scenario where I have a variable number of capacities in a work center (usually 1 or 2). I need to update the Control CapacityReduction fields. I would like to do a download of the field to see make sure it exists, if it does, then do an update. When I download the field the list is numbered 0-3. Excel does not show the 0, it leaves the cell blank. Any idea how to force it to populate with a 0 when that's the selection from the list? Any time it is already set to Formula-related I can't get it to update.

If someone know how to force the 0 to show up or another method I would love some assistance.

I could do two separate scripts, one for one capacity, one for two, but I'd like to try to keep it to one script for the end users.

Thanks,

Derek

------------------------------
Derek Sayres | SAP PLM Business Analyst
------------------------------

Sorry, I meant to say there's no padding to help since it's a single character field.

------------------------------
Derek Sayres | SAP PLM Business Analyst
------------------------------

Original Message:
Sent: 09-05-2019 10:11
From: Greg Papendick
Subject: excel download 0 as blank value - want to see 0

You may want to try padding with zero's since that may make it look like a text field to Excel.   or Post-Pad with spaces to see if it might do the same thing.  I have never encountered this with any of the field downloads that I have executed.  I have had issues with blanks appearing as zero's for number fields but that has never been a problem in my scripts.

If that does not work it may be time to submit a support ticket.  I have always had excellent service from the support team.

------------------------------
Greg Papendick | Director - Master Data
Dairy Farmers of America, Inc. | (816) 801-6458

Original Message:
Sent: 09-05-2019 09:58
From: Derek Sayres
Subject: excel download 0 as blank value - want to see 0

Hi Greg, thanks for the reply.

That box is checked. There's padding in SAP to help, I am not allowed to do a transform since it's the downloaded cell where I want 0 to display.

------------------------------
Derek Sayres | SAP PLM Business Analyst

Original Message:
Sent: 09-05-2019 08:58
From: Greg Papendick
Subject: excel download 0 as blank value - want to see 0

This sounds too simple to be the issue but have you checked to make sure that the Display options in this worksheet section of the Advanced Options has the "Show a zero in cells that have a Zero Value" box checked?


------------------------------
Greg Papendick | Director - Master Data
Dairy Farmers of America, Inc. | (816) 801-6458

Original Message:
Sent: 09-04-2019 17:29
From: Derek Sayres
Subject: excel download 0 as blank value - want to see 0

Hi,

I have a scenario where I have a variable number of capacities in a work center (usually 1 or 2). I need to update the Control CapacityReduction fields. I would like to do a download of the field to see make sure it exists, if it does, then do an update. When I download the field the list is numbered 0-3. Excel does not show the 0, it leaves the cell blank. Any idea how to force it to populate with a 0 when that's the selection from the list? Any time it is already set to Formula-related I can't get it to update.

If someone know how to force the 0 to show up or another method I would love some assistance.

I could do two separate scripts, one for one capacity, one for two, but I'd like to try to keep it to one script for the end users.

Thanks,

Derek

------------------------------
Derek Sayres | SAP PLM Business Analyst
------------------------------

Hi Derek,

I ran into the same issue where the download from Transaction shows a blank value instead of 0. According to Excel there is an advanced option to display 0 but it's not working for me.

I created a Query script that will download and show 0, although something in those tables is causing duplicates so I get two lines of data returned when I enter the plant and work center. I've attached the Query script and data file for you to take a look at. 

Since you know that blank means 0 because there has to be a value in that field, you can use that when you make updates to those fields. This might be the easier approach. 


------------------------------
Maria Simpson | Solutions Engineer
Winshuttle North America | 4255053830
------------------------------

Original Message:
Sent: 09-04-2019 17:29
From: Derek Sayres
Subject: excel download 0 as blank value - want to see 0

Hi,

I have a scenario where I have a variable number of capacities in a work center (usually 1 or 2). I need to update the Control CapacityReduction fields. I would like to do a download of the field to see make sure it exists, if it does, then do an update. When I download the field the list is numbered 0-3. Excel does not show the 0, it leaves the cell blank. Any idea how to force it to populate with a 0 when that's the selection from the list? Any time it is already set to Formula-related I can't get it to update.

If someone know how to force the 0 to show up or another method I would love some assistance.

I could do two separate scripts, one for one capacity, one for two, but I'd like to try to keep it to one script for the end users.

Thanks,

Derek

------------------------------
Derek Sayres | SAP PLM Business Analyst
------------------------------

Hi Derek

I also got the same results, no matter what the Excel settings are.  You might consider opening a Support ticket to see if this is something that could be addressed, if you like.

You could write a simple macro for lines that have blank values on a row that has a work center, swap it to blank.  But I realize it's another step.

As another option, I thought the same as Maria - a Query would work.    If you want to do an update the way you are envisioning, you would need to reformat the lines for the same work center to have all control capacity fields to be on the same row.  Query will output it one row per capacity, so that's why you are getting multiple rows on some work centers, because multiple capacities have been setup.

HTH,
Sigrid


------------------------------
Sigrid Kok
pse | Winshuttle North America
------------------------------

Original Message:
Sent: 09-04-2019 17:29
From: Derek Sayres
Subject: excel download 0 as blank value - want to see 0

Hi,

I have a scenario where I have a variable number of capacities in a work center (usually 1 or 2). I need to update the Control CapacityReduction fields. I would like to do a download of the field to see make sure it exists, if it does, then do an update. When I download the field the list is numbered 0-3. Excel does not show the 0, it leaves the cell blank. Any idea how to force it to populate with a 0 when that's the selection from the list? Any time it is already set to Formula-related I can't get it to update.

If someone know how to force the 0 to show up or another method I would love some assistance.

I could do two separate scripts, one for one capacity, one for two, but I'd like to try to keep it to one script for the end users.

Thanks,

Derek

------------------------------
Derek Sayres | SAP PLM Business Analyst
------------------------------

Here's my query example.  It uses a simple formula to add a counter for each capacity.

------------------------------
Sigrid Kok
pse | Winshuttle North America
------------------------------

Original Message:
Sent: 09-04-2019 17:29
From: Derek Sayres
Subject: excel download 0 as blank value - want to see 0

Hi,

I have a scenario where I have a variable number of capacities in a work center (usually 1 or 2). I need to update the Control CapacityReduction fields. I would like to do a download of the field to see make sure it exists, if it does, then do an update. When I download the field the list is numbered 0-3. Excel does not show the 0, it leaves the cell blank. Any idea how to force it to populate with a 0 when that's the selection from the list? Any time it is already set to Formula-related I can't get it to update.

If someone know how to force the 0 to show up or another method I would love some assistance.

I could do two separate scripts, one for one capacity, one for two, but I'd like to try to keep it to one script for the end users.

Thanks,

Derek

------------------------------
Derek Sayres | SAP PLM Business Analyst
------------------------------

Thank you all for the replies. I will enter a support ticket to see if the download (without Query, but within Transaction) can display zero.

------------------------------
Derek Sayres | SAP PLM Business Analyst
------------------------------

Original Message:
Sent: 09-06-2019 14:56
From: sigrid kok
Subject: excel download 0 as blank value - want to see 0

Here's my query example.  It uses a simple formula to add a counter for each capacity.

------------------------------
Sigrid Kok
pse | Winshuttle North America

Original Message:
Sent: 09-04-2019 17:29
From: Derek Sayres
Subject: excel download 0 as blank value - want to see 0

Hi,

I have a scenario where I have a variable number of capacities in a work center (usually 1 or 2). I need to update the Control CapacityReduction fields. I would like to do a download of the field to see make sure it exists, if it does, then do an update. When I download the field the list is numbered 0-3. Excel does not show the 0, it leaves the cell blank. Any idea how to force it to populate with a 0 when that's the selection from the list? Any time it is already set to Formula-related I can't get it to update.

If someone know how to force the 0 to show up or another method I would love some assistance.

I could do two separate scripts, one for one capacity, one for two, but I'd like to try to keep it to one script for the end users.

Thanks,

Derek

------------------------------
Derek Sayres | SAP PLM Business Analyst
------------------------------