How to summarise a formula value

[irenavassilia]

Is it possible to sum a formula within another formula in Crystal Reports 10???

Thanks.

 

[lbass]

You need to provide much more detail about what you are trying to do.

-LB

 

[dgillz]

Start with posting your formula, than as LB suggested tell use what you would like to do. Sample data and desired results are very nice too.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"If you have a big enough dictionary, just about everything is a word"
--Dave Barry

 

[Me2500]

May I jump in? I have the same question.

I have created a caculated field in Group 3 section. The field is: ({Source.Inv_Qty}-{Source.Act_Qty})*{PO_Detail.Unit_Cost}.

I now need to summarize it in the report footer. I tried using the formula wizard box, but the results I get are very wacky...sometimes 2.1x the sum of the data when I check with a calculator.

My SQL code is :


SELECT "PO_Detail"."PO", "PO_Detail"."Line",
"PO_Detail"."Status", "Source"."Material",
"Source"."Act_Qty", "Source"."Inv_Qty",
"Source"."Last_Recv_Date", "PO_Header"."Vendor",
"Vendor"."GL_Account", "Material_Trans"."Tran_Type",
"Material_Trans"."Last_Updated",
"Material_Trans"."Material_Trans_Date",
"Material_Trans"."Document", "PO_Detail"."Order_Quantity",
"PO_Detail"."Due_Date", "Material_Trans"."Quantity",
"PO_Detail"."Unit_Cost", "Source"."Last_Updated"

FROM ((("Colony"."dbo"."PO_Detail" "PO_Detail" INNER JOIN
"Colony"."dbo"."Source" "Source" ON "PO_Detail"."PO_Detail"
= "Source"."PO_Detail&quot INNER JOIN
"Colony"."dbo"."PO_Header" "PO_Header" ON
"PO_Detail"."PO"="PO_Header"."PO&quot INNER JOIN
"Colony"."dbo"."Vendor" "Vendor" ON "PO_Header"."Vendor" =
"Vendor"."Vendor&quot INNER JOIN
"Colony"."dbo"."Material_Trans" "Material_Trans" ON
"Source"."Source" = "Material_Trans"."Source"

WHERE "Vendor"."GL_Account" = '4011' AND
("Source"."Last_Updated" >= {ts '2007-04-18 00:00:00'} AND
"Source"."Last_Updated" < {ts '2007-07-18 00:00:00'})

ORDER BY "PO_Header"."Vendor", "PO_Detail"."PO",
"PO_Detail"."Line"





Any help is greatly appreciated.

 

[dgillz]

Your SQL code is not needed. Right click the field in the detail section that you want to summarize, and select insert, summary or grand total, as the case may be.

If you totals are still inflated, this is most likely due to a many to one relationship. You'll have to show sample data and explain your table relationships and grouping if this is the case.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"If the phone doesn't ring, it's me".....Jimmy Buffet