Skip to Content
0
Former Member
Jan 09, 2008 at 01:59 AM

BPS Layout formatting looks simple but tricky - Help

29 Views

Hi ,

Created a layout with the below charaterstics and Month1 give the qty for that month. It works great but

1) When there is no data i.e no qty for that month , it suppose to be blank but it gives the below out put

Currenlty :

Material mplant DType month(qty)

552477 552477

552477 552477

552477 552477

552477 552477

552477 552477

552477 552477

552477 552477

552477 552477

552477 552477

Desired :

Material mplant DType month(qty)

2) When there is data i.e qty for that month , it suppose to give two records but it gives the below out put

i.e values and some more lines with material but no qty . Actually there is data for only 2 rows.

Currently :

Material mplant DType month(qty)

552477 552477 A 10

552477 552477 B 20

552477 552477

552477 552477

552477 552477

552477 552477

552477 552477

552477 552477

552477 552477

Desired :

Material mplant DType month(qty)

552477 552477 A 10

552477 552477 B 20

I created a macro to delete the duplicate when the number repeats but that doesnot solve because when ever I want to read the total number of rows in another macro it shows wrong total number of line because of these repeating material numbers .

How can I get the desired output ? is there any simple setting in the layout or XL with out using a complicated macros etc.........

Using sem bw 320

Please help . Thank you inadvance.

Raju

Edited by: venkat bhuaptiraju on Jan 8, 2008 6:01 PM

Edited by: venkat bhuaptiraju on Jan 8, 2008 6:04 PM

Edited by: venkat bhuaptiraju on Jan 8, 2008 6:07 PM