Summing a formula field Crystal XIR2 Vantage 8.00.810C

This group is fueled by Karma.



Bruce Butler

IT Manager

Knappe & Koester, Inc.

_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of mark_wildasin
Sent: Wednesday, February 14, 2007 9:23 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Summing a formula field Crystal XIR2 Vantage
8.00.810C



Bruce,

The formula that you provided worked.
Thank you for your assistance

Mark

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"Bruce Butler" <bbutler@...> wrote:
>
> Create the field name within the formula similar to this;
>
>
>
> Whileprintingrecords;
>
> Numbervar X := {@AssmMtlQty} * {@SRIn_MtlCOST};
>
> Numbervar Total_X;
>
> Total_X := Total_X + X;
>
> X;
>
>
>
> Create another formula called something like Display_Total with
the same
> variable name;
>
>
>
> Whileprintingrecords;
>
> Numbervar Total_X;
>
> Total_X;
>
>
>
> To reset the values based on groups you need to initialize the
Total_X
> in yet another formula placed in the groups heading;
>
>
>
> Whileprintingrecords;
>
> Numbervar Total_X := 0;
>
>
>
> Note to use the Whileprintingrecords statement throughout.
>
>
>
> Bruce Butler
>
> IT Manager
>
> Knappe & Koester, Inc.
>
> _____
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
> Of paul_wetherington
> Sent: Monday, February 12, 2007 12:19 PM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Re: Summing a formula field Crystal XIR2 Vantage
> 8.00.810C
>
>
>
> Mark-
> You will have to create a running total off of your TotalCost
field in
> order to sum up the results of the formula you created.
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ,
> "mark_wildasin" <mwildasin@> wrote:
> >
> > I created a subreport and brought in the material cost for a
part.
> > I created a formula {@AssmMtlQty} * {@SRIn_MtlCOST} for the
total
> cost
> > of each material and named the formula TotalCost.
> > I now want to get a total cost for all the the materials in the
BOM.
> > I tried to create a formula and sum the TotalCost and it gave me
an
> > error that the field cannot be summarized.
> > does anyone know how I can accomplish this?
> >
>
>
>
>
>
> [Non-text portions of this message have been removed]
>





[Non-text portions of this message have been removed]
I created a subreport and brought in the material cost for a part.
I created a formula {@AssmMtlQty} * {@SRIn_MtlCOST} for the total cost
of each material and named the formula TotalCost.
I now want to get a total cost for all the the materials in the BOM.
I tried to create a formula and sum the TotalCost and it gave me an
error that the field cannot be summarized.
does anyone know how I can accomplish this?
Mark-
You will have to create a running total off of your TotalCost field in
order to sum up the results of the formula you created.



--- In vantage@yahoogroups.com, "mark_wildasin" <mwildasin@...> wrote:
>
> I created a subreport and brought in the material cost for a part.
> I created a formula {@AssmMtlQty} * {@SRIn_MtlCOST} for the total
cost
> of each material and named the formula TotalCost.
> I now want to get a total cost for all the the materials in the BOM.
> I tried to create a formula and sum the TotalCost and it gave me an
> error that the field cannot be summarized.
> does anyone know how I can accomplish this?
>
Create the field name within the formula similar to this;



Whileprintingrecords;

Numbervar X := {@AssmMtlQty} * {@SRIn_MtlCOST};

Numbervar Total_X;

Total_X := Total_X + X;

X;



Create another formula called something like Display_Total with the same
variable name;



Whileprintingrecords;

Numbervar Total_X;

Total_X;



To reset the values based on groups you need to initialize the Total_X
in yet another formula placed in the groups heading;



Whileprintingrecords;

Numbervar Total_X := 0;



Note to use the Whileprintingrecords statement throughout.



Bruce Butler

IT Manager

Knappe & Koester, Inc.

_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of paul_wetherington
Sent: Monday, February 12, 2007 12:19 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Summing a formula field Crystal XIR2 Vantage
8.00.810C



Mark-
You will have to create a running total off of your TotalCost field in
order to sum up the results of the formula you created.

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"mark_wildasin" <mwildasin@...> wrote:
>
> I created a subreport and brought in the material cost for a part.
> I created a formula {@AssmMtlQty} * {@SRIn_MtlCOST} for the total
cost
> of each material and named the formula TotalCost.
> I now want to get a total cost for all the the materials in the BOM.
> I tried to create a formula and sum the TotalCost and it gave me an
> error that the field cannot be summarized.
> does anyone know how I can accomplish this?
>





[Non-text portions of this message have been removed]
Bruce,

The formula that you provided worked.
Thank you for your assistance

Mark

--- In vantage@yahoogroups.com, "Bruce Butler" <bbutler@...> wrote:
>
> Create the field name within the formula similar to this;
>
>
>
> Whileprintingrecords;
>
> Numbervar X := {@AssmMtlQty} * {@SRIn_MtlCOST};
>
> Numbervar Total_X;
>
> Total_X := Total_X + X;
>
> X;
>
>
>
> Create another formula called something like Display_Total with
the same
> variable name;
>
>
>
> Whileprintingrecords;
>
> Numbervar Total_X;
>
> Total_X;
>
>
>
> To reset the values based on groups you need to initialize the
Total_X
> in yet another formula placed in the groups heading;
>
>
>
> Whileprintingrecords;
>
> Numbervar Total_X := 0;
>
>
>
> Note to use the Whileprintingrecords statement throughout.
>
>
>
> Bruce Butler
>
> IT Manager
>
> Knappe & Koester, Inc.
>
> _____
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf
> Of paul_wetherington
> Sent: Monday, February 12, 2007 12:19 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Summing a formula field Crystal XIR2 Vantage
> 8.00.810C
>
>
>
> Mark-
> You will have to create a running total off of your TotalCost
field in
> order to sum up the results of the formula you created.
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
> "mark_wildasin" <mwildasin@> wrote:
> >
> > I created a subreport and brought in the material cost for a
part.
> > I created a formula {@AssmMtlQty} * {@SRIn_MtlCOST} for the
total
> cost
> > of each material and named the formula TotalCost.
> > I now want to get a total cost for all the the materials in the
BOM.
> > I tried to create a formula and sum the TotalCost and it gave me
an
> > error that the field cannot be summarized.
> > does anyone know how I can accomplish this?
> >
>
>
>
>
>
> [Non-text portions of this message have been removed]
>