Print Page | Close Window

Summarise Formula Field

Printed From: Crystal Reports Book
Category: Crystal Reports .NET 2003
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=17881
Printed Date: 19 Apr 2025 at 12:57pm


Topic: Summarise Formula Field
Posted By: reneek
Subject: Summarise Formula Field
Date Posted: 30 Oct 2012 at 5:08pm

hi there

 

i need to total/summarise a formula field in crystal reports.

 

i know crystal cannot do this but was hoping someone could help me with a work around.

 

the formula in the column/field i need to summarise is:

 

if{@Trade CAP}<0 then {@Trade Capacity per Month} else

Sum ({ps_20MonthSpreadSum.MANHRS}, {ps_20MonthSpreadSum.Resource})

 

Thanks in advance

 

regards

Renee



Replies:
Posted By: comatt1
Date Posted: 31 Oct 2012 at 3:47am
use shared variables
-----

shared numbervar totalsum:=0;

if{@Trade CAP}<0 then
totalsum:={@Trade Capacity per Month} else
Sum ({ps_20MonthSpreadSum.MANHRS}, {ps_20MonthSpreadSum.Resource});

totalsum


Print Page | Close Window