Percentage calculation in CR XI 1

[Zanz38]

Hi,

I've written a database and have now written the report for it, this is based on an Excel spread sheet. In CRXI I would like to replicate this formula =SUM((S17-S14)/S17) but am not sure how to do this? can anybody help?

In a nutshell I am trying to work out Actual Availabilty by Subtracting "Actual Number of Minutes downtime" from "Net Minutes" times "Net Minutes"

e.g 43865 - 351 X 43865 = 99.20

351 minutes of Application downtime in a month with 43865 Minutes of Planned Operational time would give you 99.20% application availability for the month.

the database fields are

"Actual Number of Minutes downtime" = Sum of qry_VMI_Outages.Dongguan_Duration

"Net Minutes" = qry_VMI_Outages.Available_minutes


Any help would be most appreciated
Cheers

Andy

 

[dgillz]

Sum({YourField})%{YourOtherField}

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"What version of URGENT!!! are you using?

 

[Zanz38]

Thank you, while your reply didn't return the correct value after a bit of tweaking I got the right formula

({qry_VMI_Outages.Available_minutes} - Sum ({qry_VMI_Outages.Dongguan_Duration}, {qry_VMI_Outages.MonthID}))/ {qry_VMI_Outages.Available_minutes}*100

If you hand't have advised me of the inital bit i would still be chasing my tail so big thanks,

 

[dgillz]

If you use the % sign instead of a slash /, you won't have to multiply by 100.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"What version of URGENT!!! are you using?

 

[Zanz38]

Excellent thank you