Sum for Formula Field in Crystal Report 2008 !!!

[Former Member]

Hello Expert,

How to summarized formula field in crystal report. I have 1 report in which I have put formula to get received value, but I want to sum that formula field(Received Value) in my crystal report 2008.

I have tried below formula but It didn't give me correct result.

{@Initializer} WhilePrintingRecords; Numbervar dSum :=0;

{@Increment} WhilePrintingRecords; Numbervar dSum; //Don't initialize zero dSum:=dSum+{@Net}; //{@Net} formula field must be return numeric value

{@Total} WhilePrintingRecords; Numbervar dSum; //Don't initialize zero dSum;

Please advise.

Regards,

Harshal Makwana

[Former Member · Accepted solution]

Hi Harshal,

Go to Running total Fields in Field Explorer and right click on it and make your Field For total

and if you have already made your formula then select it and [>] click it to put your formula to Field to Summarize then from Type of Summary Drop Down select Sum and  click ok. Now you can see your

New formula at Below List in Running total Fields You can put it where you want to see total.

Regards,

Abhi Patel

[Former Member · Accepted solution]

Hi Abhi,

Thanks for the solution. It works perfectly now.

Thanks again.

Regards,

Harshal Makwana

[Former Member · Accepted solution]

HI, Harshal

     Welcome and Please close the thread if you are satisfied with my answer.

Regards,

Abhi Patel