<html><div style='background-color:'><DIV class=RTE>
<P>You may want to ask this question on the Impromptu list at ittoolbax.com</P>
<P>There may be an easier way.</P>
<P>But here are some ideas.</P>
<P>defne x as count reset at month</P>
<P>def value as budget if x = 1 else 0</P>
<P>def year_budget total value<BR></P>
<P>Regards,</P>
<P>Peter Bateman<BR></P></DIV>
<DIV></DIV>
<BLOCKQUOTE style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #a0c6e5 2px solid; MARGIN-RIGHT: 0px"><FONT style="FONT-SIZE: 11px; FONT-FAMILY: tahoma,sans-serif">
<HR color=#a0c6e5 SIZE=1>
<DIV></DIV>From: <I>shulbert@clblf.com</I><BR>To: <I>powerh-l@lists.sowder.com</I><BR>Subject: <I>quiz to impromptu</I><BR>Date: <I>Wed, 14 Dec 2005 15:39:37 +0000</I><BR>>seeing that the cognos bi helpdesk person seemed unaware that there was a product called quiz, in desperation i'm asking the list.<BR>><BR>>i'd like to reproduce the "subtotal at" functionality in impromptu.<BR>><BR>>that is, subtotal a value only once per sort group.<BR>><BR>><data><BR>>Rep Year Month Budg£ Invoice Amount£<BR>>------------------------------------------<BR>>Rep1 2005 1 1000 IV000001 57.91<BR>>Rep1 2005 1
1000 IV000002 34.51<BR>>Rep1 2005 1 1000 IV000003 37.66<BR>>Rep1 2005 1 1000 IV000004 86.57<BR>>Rep1 2005 2 1010 IV000005 41.69<BR>>Rep1 2005 2 1010 IV000006 58.46<BR>>Rep1 2005 2 1010 IV000007 59.62<BR>>Rep1 2005 2 1010 IV000008 26.15<BR>>Rep1 2005 2
1010 IV000009 52.23<BR>>=========================================<BR>>Rep1 2005 2010 454.80<BR>></data><BR>><BR>>i.e. the budget amount on the summary line is the sum of the budget figure for each month, but only including that figure once.<BR>><BR>><quiz><BR>>access invoices & link rep to rep of rep_budgets<BR>>sort on rep on year on month<BR>>footing at year rep year budget subtotal at month amount subtotal<BR>>go<BR>></quiz><BR>><BR>>many thanks for your patience,<BR>>stephen.<BR>><BR>><BR>.<BR></FONT></BLOCKQUOTE></div><br clear=all><hr>Free yourself from those irritating pop-up ads with <a href="http://g.msn.com/8HMAENCA/2752??PS=47575" target="_top">MSN Premium:</a> Join now and get the first two months FREE*</html>