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

    LB, It worked....I'm such an idiot. I've been trying the same formula but I am using or previous({table.FinDate}) = " " instead of previous({table.FinDate}) = datetime(1970,1,1,00,00,00)) that's why. Thanks.. your awesome!!!
  3. thi123

    Need to remove unwanted Values!

    LB, Can you explain further what you mean to "also explain what value you want to use in the formula instead of the previous value if the previous value = 1/1/1970."? Sorry, I just don't get it. Waiting...
  4. thi123

    Need to remove unwanted Values!

    Thanks for the quick reply guys. Here's the formula I used to calculate the # of days field. if {#CntGrpTotal} = 1 and not(isnull({Table.FinDate})) and {Table.FinDate} <> datetime(1970,1,1,00,00,00) then totext({Table.FinDate}-{Table.OrdDate}) else if {Table.FinDate} =...
  5. 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...
  6. thi123

    Need formula to remove unwanted dates

    Thanks synapsevampire, I got it. The formula is working. [smile2]
  7. thi123

    Need formula to remove unwanted dates

    synapsevampire, I used your suggestion with a slight modification but I am still getting the same result. The wrong values are still showing... What I am missing???? if {#OrderRecord} = 1 and not(isnull({table.FinDate})) and {table.FinDate} <> cdate(1970,1,1) then...
  8. thi123

    Need formula to remove unwanted dates

    Hi synapsevampire, Have to correct the typo again. The formula is: if {#OrderRecord} = 1 then {FinDate}-{OrdDate} else {FinDate}-previous{OrdDate} Duh!!! I'm such a DORK.....
  9. thi123

    Need formula to remove unwanted dates

    Hi synapsevampire, sorry, that is a typo. it is supposed to be: if {#OrderRecord} = 1 then {FinDate}-{OrdDate} else {FinDate}-{FinDate} I will go ahead and try your suggestion. Thanks again.
  10. thi123

    Need formula to remove unwanted dates

    Thanks dgillz, Can I add your recommendation on my formula or do I need to create a separate formula for Not IsNull({FinDate})?
  11. 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...
  12. thi123

    Need to get the Average Discount % of the Order

    synapsevampire, Thank you so much. Your formula works. I have now the correct values on my report. You guys are great!!!!
  13. thi123

    Need to get the Average Discount % of the Order

    Mr BillSC, Yes I am using the Sum function for all the elements of my group calculation. sample: Sum ({@OrdAmt}, {Order.OrdNo})-Sum ({NetAmt}, {Order.ordNo})/Sum ({@OrdAmt}, {Order.OrdNo}) Thanks for all quick reply.
  14. 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...
  15. thi123

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

    Thanks to both of you guys; tektipdjango and lbass. I got the report running and the output came out correct using lbass formula. [2thumbsup]
  16. thi123

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

    Hi tektipdjango, I used your recommended formula but it did not work. All I was getting was "Zero". I need to calculate the date difference between the time that the Spec was signed off and the Dis Form was delivered. So, I have to base the calculation on the FinDt/time. I cannot use the...
  17. thi123

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

    Thanks tecktipdjango for your quick response. I forgot to add that I am only using the order date to get the starting figure. The rest of the calculation will be based on the date that the Spec was completed minus the date that the Disc was completed. I will try and see if your recommendation...
  18. 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