Report development question

[Eli_Boone_(Guest)]

Hello, I am trying to create a report that will list every stock item and the total sales for the stock items for each year.____Output would look something like this:____stock # 2004 Sales 2003 Sales 2002 Sales______AG2333 $4503.00 $3922.00 $3444.95__________I am using MOM 5.0 and have cms.dbf as my Master Table.____I just have one exact relationship between cms.dbf and items.dbf.__Does that seem like the only relationship that I need for this report to work?____thanks, eli

[Eli_(Guest)]

Ok, I am trying to figure out how to create the correct calculations for this report. Here is what I have come up with so far.____IIF(ODR_DATE > 12/31/04) sum (ITEM * IT_UNLIST) ____This calculation would be called 2004_calc (or something like that).____I know that my syntax is off because I don^t know exactly how to set this calculation up right. ____Does anyone know what the correct syntax would be for this calculation? Does it look like this calculation will achieve what I want?____Thanks a lot,____eli

[kfleming]

It sounds like you need a set of conditional totals.____First create a calculated field whose expression will be:__(ITEM * IT_UNLIST) __this will give you the extended amount____Then you need 3 total fields. Each will be a sum of the above calculation. But for each total you will have a different condition.____For the 2004 total it would be:__YEAR(ODR_DATE)=2004____You^d then use the same format for each other year.____Kathleen__R&R Support____

[Eli_Boone_(Guest)]

Hi Kathleen,____Thanks a lot for the info. I keep trying to create a calculated field by doing the following.____Calculations menu/Calculated Field.../New____I scroll down to ITEM in the ^Fields:^ box and double click on it so it is displayed in the ^Expression:^ window. Then I click on the * operator. Finally I scroll down to IT_UNLIST and double click on it so I have the following in the ^Expression:^ window.____ITEM*IT_UNLIST ____I also gave the Calculated Field a name ITM_SPCL.____When I click on Verify I receive the message "Invalid Operation"____I have tried putting parentheses around the expression, adding spaces around the *, but nothing works. I feel like an idiot.____I am using CMS as my Master Table. I even tried using ITEMS as my Master Table just to see if that would work but no luck.____What am I doing wrong now?____Thanks, eli

[kfleming]

To perform multiplication, each of the fields needs to have a numeric data type.____Kathleen__R&R Support