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

  • Users: sbf
  • Order by date
  1. sbf

    Prevoius maximum

    Thanks Ibass, it works perfect. My example represents data for one day. I have data for more days and are grouping by day. I have tried to reset the maxend value in the Group Header with: @reset whileprintingrecords; numbervar maxend:=0; But the calculation continues with the maximum maxend...
  2. sbf

    Prevoius maximum

    Hi Everyone, I need help CRW 8.5 on SQL Server. I have the following data set: Start End Lane RT_NR Diff (NR) 10,00 17,00 NR 17 14,00 15,00 NR 17 14-17= -3 16,00 19,00 NL 17 18,00 20,00 NR 20 18-17= 1 21,00 24,00 NL 20 23,00 25,00 NR 25 23-20= 3 23,00...
  3. sbf

    First in - first out

    Hi Ngolem The RECIEIPT works ok, but I still have a problem with the ISSUE part. With qty <=7 in line 3, ISSUE part, gives the right result : Lot issue date qty price curbal value A RECEIPT 01-12 7 10 7 70 B RECEIPT 02-12 4...
  4. sbf

    First in - first out

    Thanks a lot Ngolem, I regret my late response, I just got back to the office today. Yes, my problem is to calculate the Value and curbal of products in the storeroom. Yes, date is more important than lot. We will receive not more than one shipment (Lot) per day of each Product ID, so I...
  5. sbf

    First in - first out

    Thanks for your reply dgillz and Madawc My problem is to make a formular to calculate the actual store value on the latest record date (newest)In my example, 5. Dec, where the field Issue = ISSUE. The formula should be something like: If curbal (line 5) <= quant (line 4 ) then curbal (line...
  6. sbf

    First in - first out

    Hi Everyone I want to calculate the store value, based on the “first in - first out principle” for each item. When items are issued the earliest(oldest) items are taken from the store. lot issue date quant price curbal value A RECEIPT 01-12 7 10 7 7*10=70 B RECEIPT 02-12 4...
  7. sbf

    Calculate a value based on a previous value

    Just perfect - - Thanks you for your reply basil3legs. Yes, cur_bal is a running total of the quant field. The formula gives the right value on this example, but it is not a god example. Yes, it is unclear what happens if the u_price is 24 of instead of 20 in line 7, and I will try explain...
  8. sbf

    Calculate a value based on a previous value

    Hi Everyone, I need help I have the following records in a table and want to calculate the last column “value” The calculation is dependent of the change of ‘issuetype’ RECEIPT. Item issuetype date quant u_price cur_bal value 0001 RECEIPT 01-09 12 20 12 12*20=240 0001...
  9. sbf

    Montly rating using the most recent value if no data for the month

    Thanks Ibass, your assistance has helped me greatly. I did a slight modification to your formula, as the recent rating sometimes is more than one month old: {@sumMar}: if sum({@Mar},{table.GLAcct}) >0 then sum ({@Mar},({table.GLAcct}) else if sum({@Feb},{table.GLAcct})>0 then...
  10. sbf

    Montly rating using the most recent value if no data for the month

    Thanks again Ibass I have tried your proposal which gives the following output: JAN-03 FEB-03 MAR-03 APR-03 MAY-03 JUN-03 JUL-03 (GH1) 1111 ----------------------------------------------------------------------------- 1111 0 0 0 0 0...
  11. sbf

    Montly rating using the most recent value if no data for the month

    Thanks Ibass Ok I’ve made 8 formulas starting with{@Dec}, (data starts in dec) and group on GLAccount and inserted summaries on these formulars {@Dec} if {KLA_RATING.RATINGDATE} in dateadd(&quot;m&quot;, -8, date(year(currentdate),month(currentdate),01)) to...
  12. sbf

    Montly rating using the most recent value if no data for the month

    Report output again! Rating Glaccount JAN-03 FEB-03 MAR-03 APR-03 MAY-03 JUN-03 JUL-03 1111 4 3 3 3 4 4 2 2222 3 3 3 3 2 2 1...
  13. sbf

    Montly rating using the most recent value if no data for the month

    Thanks for your reply synapsevampire. Ups, formatting problem on Report output columns, the rating values have slipped to far to the left side, I will try again: Rating Glaccount JAN FEB-03 MAR-03 APR-03 MAY-03 JUN-03 JUL-03 1111 4 3 3...
  14. sbf

    Montly rating using the most recent value if no data for the month

    Hi Everyone, I need help ! I have the following records in a table: GlAccont Rating Ratingdate 1111 4 22-JAN-2003 1111 3 13-FEB-2003 1111 4 05-MAY-2003 1111 2 06-JUL-2003 2222 3 12-DEC-2002 2222 2 07-MAY-2003 2222 4...

Part and Inventory Search

Back
Top