Print Page | Close Window

formula using sums & count

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=4308
Printed Date: 02 May 2024 at 7:08am


Topic: formula using sums & count
Posted By: carstowal
Subject: formula using sums & count
Date Posted: 19 Sep 2008 at 8:16am
I need to add (2) sums and divide it by a count
then subtract the result from 1
and display the final result as a percentage
 
1-  (
(Sum of mailto:%7b@rDE - {@rDE } + Sum of mailto:%7b@rDL - {@rDL }) 
  / 
Count of {vwVDR.D_R_D}    )
 
 
result = 1 - ((3 + 5) /20)  = 60%
 
in a group footer where fields containing all this reside
 
TIA
 
editted
or I could use Sum of mailto:%7b@DDC - @DDC  instead of the Count, it's the same thing


Print Page | Close Window