Crystal Reports Unable to sum Formula field.

Tips and Tricks
Crystal Reports Forum : Crystal Reports 9 through 2020 : Tips and Tricks

Topic: Unable to sum Formula field.

Author	Message
krishreddy Newbie Joined: 18 May 2012 Location: India Online Status: Offline Posts: 11	Topic: Unable to sum Formula field. 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.
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	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
	IP Logged

Post Reply

Post New Topic

Printable version

Printable version

Forum Jump

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum

This page was generated in 0.016 seconds.