Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2005
    Provided Answers: 1

    Question Unanswered: Help - My data is in QTD but I need YTD

    The totals below are reporting QTD, but I need totals in YTD how can I get that in DB2?

    Territory Sales Amount Quota Date
    East $580,000 $1,000,000 6/1/2014
    West $1,900,000 $1,000,000 5/1/2014

  2. #2
    Join Date
    Apr 2006
    Provided Answers: 11
    if no details are provided, members can only guess to what you mean or try to accomplish.
    I would say : divide results by 4 or any other digit to reflect other quantities.. all is up to you.. you don't even need db2 for that..
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5-V11 Fundamentals- DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts