Print Page | Close Window

Unable to sum Formula field.

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2022
Forum Name: Tips and Tricks
Forum Discription: Have you learned some great tricks to share with the group? Post them here!
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=17021
Printed Date: 04 May 2025 at 6:40pm


Topic: Unable to sum Formula field.
Posted By: krishreddy
Subject: Unable to sum Formula field.
Date Posted: 12 Jul 2012 at 9:33pm
Hi,

to avoid duplicates I am creating formula field like below
"if {GLPCA.RACCT}=previous({GLPCA.RACCT}) and {GLPCA.KSL}=previous({GLPCA.KSL}) then 0 else {GLPCA.KSL}"
But Here I am unable to sum this formula field.
Could you please suggest me how can I do it.


Replies:
Posted By: DBlank
Date Posted: 17 Jul 2012 at 3:41am
you have to use a variable formula or a Running total.
I prefer a RTs
example:
name=KSL_sum
field to summarize=KSL
type=sum
evaluate=use a formula
{GLPCA.RACCT}<>previous({GLPCA.RACCT}) and {GLPCA.KSL}<>previous({GLPCA.KSL})
reset=never (for a report total)
place in report footer


Print Page | Close Window