Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Zanz38

    Averaging a sum field

    Sorry about the delayed response, thank you I will have a crack at either of these solutions
  2. Zanz38

    Averaging a sum field

    Hello, Back again!! I am trying to do an average figure of a formula "{@VMI Solution Availability}" by using the following text "Average ({@VMI Solution Availability})" and CR XI advises "this field can not be summarised" "{@VMI Solution Availability}" is calculated using...
  3. Zanz38

    Percentage calculation in CR XI

    Excellent thank you
  4. Zanz38

    Percentage calculation in CR XI

    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...
  5. Zanz38

    Percentage calculation in CR XI

    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...

Part and Inventory Search

Back
Top