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 Rhinorhino 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: *

  • Users: thi123
  • Content: Threads
  • Order by date
  1. thi123

    Looking to create AGING report based on # of Transaction each month.

    I’m looking to create an aging report calculating the number of transaction that was completed between dates based on the following field: Field Description end date # of days compl from Odr days to Frm comp Frm comp to Instr Instr comp to installe Prod install to tested frm comp...
  2. thi123

    Need to remove unwanted Values!

    I was calculating the number of days based on the current and previous dates. Previously, I got a tip from synapsevampire for the formula I used to removed the unwanted dates and calculate the number of days correctly, however I still have this value that I cannot git rid of. Here’s the sample...
  3. thi123

    Need formula to remove unwanted dates

    My report displays data including dates that does not exists on the database. I think these are the default dates and I don't want these to display on the report. I group the report based on the Order No. I have the formula that calculates number of days when the order was placed and the...
  4. thi123

    Need to get the Average Discount % of the Order

    I am trying to calculate the Average Discount % of an Order using the Group result but I was not getting the correct figure. I got the correct figure on the details section using this formula: OrdAmt-NetAmt/OrdAmt = AveDisc % Appying this formula on the Group result figure below, I should...
  5. thi123

    How to calculate number of days base on the same field?

    I need to calculate the number of days that the work was completed from “Spec Complete” to Dis Complete. I started calculating the number of days by deducting the Fin Date/time to OrderDt to start the beginning figure. However, I could not get the correct formula to calculate the number of days...

Part and Inventory Search

Back
Top