Search results for query: *

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,

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

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,

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

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

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

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,

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

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

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

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

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