Brian,
Thanks, Running Totals was the answer.
Mike
Thanks, Running Totals was the answer.
Mike
--- In vantage@yahoogroups.com, "Brian Roberts" <broberts@...> wrote:
>
> Mike, as a possible alternative to all these formulas... look at running
> totals in Crystal. You can have a value total only at the change of
> some other fields or group, and when it resets. Haven't looked at your
> original requirements in details, but might work for you.
>
>
>
> Brian.
>
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of Mike Numbers
> Sent: Tuesday, September 11, 2012 3:41 PM
> To: vantage@yahoogroups.com
> Subject: RE: [Vantage] Summing group footer amounts
>
>
>
>
>
> I see how this is supposed to work, but when I create my "LaborTally"
> field
> it ends up be a Boolean type field. Below is my formula. I have tried it
> with Global in front of CurrencyVar and without Global. Do you see what
> I
> am doing wrong? This is copied from the Formula Workshop window when I
> create a new formula and give it a name of LaborTally.
>
> CurrencyVar LaborTally;
>
> if (Previous
> ({BAQReportResult.QuoteOpr.OprSeq})<>{BAQReportResult.QuoteOpr.OprSeq})
>
> then LaborTally = (LaborTally + {@LaborCost})
>
> else LaborTally = (LaborTally)
>
> Mike
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
> Behalf Of
> Vic Drecchio
> Sent: Tuesday, September 11, 2012 3:00 PM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: RE: [Vantage] Summing group footer amounts
>
> Sorry, not a "shared" variable; *global* variable.
>
> Check this out. It should kickstart you:
> http://www.youtube.com/watch?v=DNJfG0Af3wM
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com>
> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com> ] On
> Behalf Of
> Mike Numbers
> Sent: Tuesday, September 11, 2012 2:52 PM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com>
> Subject: RE: [Vantage] Summing group footer amounts
>
> I am not following you. I looked up shared variable and it appeared to
> be
> used with sub reports. I currently am not using a sub report. I also did
> not understand how the PreviousFld function would work in your
> situation.
> It sounds like what I had tried.
>
> Any chance of explaining in more detail. It's just not registering right
> now.
>
> Mike
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com>
> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com> ] On
> Behalf Of
> Vic Drecchio
> Sent: Tuesday, September 11, 2012 2:26 PM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com>
> Subject: RE: [Vantage] Summing group footer amounts
>
> You can't use PreviousFld in a Sum because it occurs during the
> WhenPrintingRecords phase of the report.
>
> You'll have to create a shared variable. In that shared variable. call
> it
> "LaborTally" and then you will be able to use your PreviousFld function
> and
> tally up the total. Then display that tallied field in your RF.
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com>
> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com> ] On
> Behalf Of
> mike.numbers
> Sent: Tuesday, September 11, 2012 2:18 PM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Summing group footer amounts
>
> I am trying to create a report to replace the Quote Worksheet. My BAQ
> links
> the QuoteMtl and QuoteOpr by line and Oprseq/RelatedOprSeq. I am
> printing
> the QuoteMtl in detail time and QuoteOpr in group footer time. The
> report is
> printing correctly. My problem is when I try to get totals. I am summing
> the
> material cost from the detail line and that value is correct. When I sum
> the
> labor costs from the group footer operation level, I am getting an
> inflated
> amount because my QuoteOpr line is internally duplicated for each
> material.
> I tried using Previous Fld to create a workfield that would be 0 if the
> previous oprseq = the current oprseq. There were no errors in the
> formula.
> When I put the work field on the report, it shows it is a number. When I
> click on the summation icon the new field does not come back in the
> field to
> be summarized.
> Is there another way to get the report to sum only the fields printing
> and
> not the duplicate values in the BAQ or am I doing something wrong when
> creating the work field using Previous Fld?
>
> Any help would be appreciated.
> Mike
>
> No virus found in this message.
> Checked by AVG - www.avg.com
> Version: 2012.0.2221 / Virus Database: 2437/5262 - Release Date:
> 09/11/12
>
> -----
> No virus found in this message.
> Checked by AVG - www.avg.com
> Version: 2012.0.2221 / Virus Database: 2437/5262 - Release Date:
> 09/11/12
>
> [Non-text portions of this message have been removed]
>
> [Non-text portions of this message have been removed]
>
> No virus found in this message.
> Checked by AVG - www.avg.com
> Version: 2012.0.2221 / Virus Database: 2437/5262 - Release Date:
> 09/11/12
>
> -----
> No virus found in this message.
> Checked by AVG - www.avg.com
> Version: 2012.0.2221 / Virus Database: 2437/5262 - Release Date:
> 09/11/12
>
> [Non-text portions of this message have been removed]
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
> [Non-text portions of this message have been removed]
>