Joined: 23 Aug 2010
Online Status: Offline
Posts: 11
Topic: Percentage formula Posted: 24 Aug 2010 at 12:14am
Can a sum be calculated using a COUNT field as i cant seem to get it right, maybe i'm way off the ball on this though.. formula i'm trying is this.... sum({@weeks } / {Count of HSW.FormDate }) * 100
Can anyone point me in the right direction and bear in mind i'm very new to crystal reporting.
Joined: 23 Aug 2010
Online Status: Offline
Posts: 11
Posted: 25 Aug 2010 at 9:06am
Thanks DBlank
I must be doing something wrong i appear to get the same result for every record even though i know they should be different..
The formula does use the result of the COUNT and said formula @weeks and divide to show a percentage?
the result of @weeks is 10 and COUNT of HSW.FormDate is 8 and should show 80% but i get the result 141 for every record....any ideas where i may be going wrong?
Joined: 23 Aug 2010
Online Status: Offline
Posts: 11
Posted: 26 Aug 2010 at 10:16pm
This counts the total of reports for a contract ControlofFormDate2: Count of HSW.FormDate divided by a result of formula @weeks which is datediff ("w", {CON.OnSiteStart},currentdate) these are placed in my group footer #3.
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