Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: formula using sums & count Post Reply Post New Topic
Author Message
carstowal
Groupie
Groupie


Joined: 31 Jul 2008
Online Status: Offline
Posts: 80
Quote carstowal Replybullet Topic: formula using sums & count
    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 {@rDE} + Sum of {@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 @DDC instead of the Count, it's the same thing


Edited by carstowal - 19 Sep 2008 at 8:33am
IP 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.035 seconds.