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!

Recent content by thi123

  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]
See more

Part and Inventory Search

Back
Top