Subtotal calculation

[Greig Morrison]

The simplest way would change the report layout.

Sort on Part_Number &
     On Part_Group

Report Part_Number Part_Group Part_Price

Footing at Part_Group  "Subtotal :" Part_Group Part_Price subtotal

Footing at Part_Number "Subtotal :" Part_Number Part_Price subtotal


          Part Number         Part Group        Part Price

                   A 		 123		 		 300
		       A		 123
100

Subtotal :                     123                     400

		       A		 456
400
		       A           456                     400

Subtotal :                     456                     800
------------------------------------------------------------------------
---------------------------

Subtotal :   A                                       1,200

                   B           123		 		 200
		       B		 123
100

Subtotal :                     123                     300

		       B		 456
100
		       B           456                     400

Subtotal :                     456                     500
------------------------------------------------------------------------
---------------------------

Subtotal :   B                                         800



For your layout I would use multiple passes in Quiz with an intermediary
subfile and a Defined item to control the report break points for the
report-group. 

e.g. The subfile could look like this and the final report would use a
Define item to conditionally change; detail lines for "0"s and subtotal
lines for "1"s and control additional line spacing with Footing AT
statements:


  A0               A 		 123		 		 300
  A0  	       A 		 456		 		 400
  A0  	       A		 123		 		 100
  A0  	       A           456                     400
  A1		                   123                     400
  A1                           456                     800
  B0               B           123		 		 200
  B0		       B		 456
100
  B0		       B		 123
100
  B0		       B           456                     400
  B1					 123
300
  B1					 457
500


Regards
Greig

-----Original Message-----

Date: Fri, 12 Nov 2010 15:50:10 +0530
From: Pandurang Rajpurohit <pandurang.rajpurohit at in.ibm.com>
Subject: Subtotal calculation
To: powerh-l at lists.sowder.com
Cc: Nisha Pawar <nishapawar12 at gmail.com>
Message-ID:
	
<OF199C455D.6C429768-ON652577D9.0038A5D2-652577D9.0038E258 at in.ibm.com>
Content-Type: text/plain; charset="us-ascii"



Hello Team,

Please suggest as to how to achieve the below example subtotal query.
Here there are few parts of different groups , and a report is being
generated which will be shown in the below format.

Now the subtoal is given at the footing line and it has been given
footing at part number which is the sorting key also.
Now again i want to subdivide the part group wise subtotal , please
suggest is this possible in powerhouse.




          Part Number         Part Group        Part Price

                   A 		 123		 		 300
		       A`		 456
400
		       A		 123
100
		       A           456                     400

------------------------------------------------------------------------
---------------------------

Subtotal :   A                 123                     400
                               456                     800

                   B           123		 		 200
		       B`		 456
100
		       B		 123
100
		       B           456                     400

------------------------------------------------------------------------
---------------------------

Subtotal :   B                  123                    300
                                457 		       500

(See attached file: Sample calculation.doc)


Thanks & Regards
Pandurang Rajpurohit,
-----------------------------------------------------------------
Project Manager
GM - Powerhouse Tower (DDS)
IBM Global Services India Pvt. Ltd. Pune
Land line : +91 020 40116372
Hand Line : +91 9049009973
EMAIL : pandurang.rajpurohit at in.ibm.com
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Sample calculation.doc
Type: application/msword
Size: 20480 bytes
Desc: not available
Url :
http://lists.sowder.com/pipermail/powerh-l/attachments/20101112/a6208176
/attachment.doc 

------------------------------

-- 
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l at lists.sowder.com
Subscribe: &quot;subscribe&quot; in message body to
powerh-l-request at lists.sowder.com
Unsubscribe: &quot;unsubscribe &lt;password&gt;&quot; in message body to
powerh-l-request at lists.sowder.com
http://lists.sowder.com/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.
Add 'site:lists.sowder.com powerh-l' to your search terms to search the
list archive at Google.

End of powerh-l Digest, Vol 66, Issue 3
***************************************