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 Mike Lewis 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. kfr104

    division

    I used compute instead of Define and it worked. However, I have a column that I am doing CNT.DST and I want to use that number and divide it into sales but it does not work. What do I have to do to the formula to make it work? Thanks,
  2. kfr104

    Reports running faster

    Once I put in the Define fields it runs a lot slower...I wait 3-5 minutes for the report to come up. 2007Sales/P12= IF AGENCY_SALES_V.AGENCY_SALES_V.YR EQ '2007' THEN AGENCY_CURR_SALES ELSE 0 2008Sales/P12= IF AGENCY_SALES_V.AGENCY_SALES_V.YR EQ '2008' THEN AGENCY_CURR_SALES ELSE 0...
  3. kfr104

    Reports running faster

    I have a several Defined fileds in my report and it is taking for ever to run the report in painter...Is there anything I can do to make them display faster? Thanks,
  4. kfr104

    division

    I am using the define function and when I am doing the division function I am getting number that are not correct... I am dividing two P12 formats and trying to get a percentage...and it is not working out. What am I doing wrong? Thanks, Kerry
  5. kfr104

    Combining numbers from two seperate columns

    It worked...thank you everyone for your help!
  6. kfr104

    Combining numbers from two seperate columns

    I have tried the first two formulas you gave me and this is what I get The first one I recieve: (FOC282) RESULT OF EXPRESSION IS NOT COMPATIBLE WITH THE FORMAT OF FIELD: DATE When checking the second formula I recieve this error (FOC253) INVALID FORMAT SPECIFICATION ON LEFT HAND SIDE: I6YM...
  7. kfr104

    Combining numbers from two seperate columns

    The month column is an I11 and the year column is I 11 and of course the date in the month column is 1-12 and the year is a 4 digit number. I hope that is what you were looking for. thanks,
  8. kfr104

    Creating Columns

    Good Day I have a database with column that contains years and coresponding column that has sales in it. I want to creat indepentet fields in the report that have 2007 Sales and another one that has 2008 sales. I could do the years across and then sum the sales underneath it, but then i will...
  9. kfr104

    Combining numbers from two seperate columns

    I am not quite sure what you mean... I have been displaying both the month and year and then the combined field and the combined field shows 00/0000. Can you please tell me why it is showing this? Kerry
  10. kfr104

    Combining numbers from two seperate columns

    EDIT(AGENCY_SALES_V.AGENCY_SALES_V.MTH, '99') | '/' | EDIT(AGENCY_SALES_V.AGENCY_SALES_V.YR, '9999') I used this statment A8 and the result for everything is 00/0000. Why is it not working? Thanks, Kerry
  11. kfr104

    Combining numbers from two seperate columns

    I have a column that is 1-12 which equals a month and then I have a column that has the year. I am trying to combine them, so that it will be month/year. I have tried to figure out how to do it in the painter, but everything I have tried does not work. What is the best function to use to...
  12. kfr104

    Combining numbers from two seperate columns

    How can i combine two numerical comlumns togeter. Ie. the month is 12 and year is 2007, which would equal 12/2007. Thanks,

Part and Inventory Search

Back
Top