Search results for query: *

Hello All, I am using Access 2007. I have created a crosstab that does unit sells per week for a specified date range (Over 20 weeks). The crosstab looks as such (The last column is what I am trying to create): Week 1 Week 2 Week 3 Week 4 Total Weeks Item A 1 2...

I currently have a cross tab report in XI that gives me 52 weeks of sales data for my items. I want to run a calculation that will look through the cross tab and tell me the number of weeks that there were sales more than a certain amount. Is this possible?

Hello All, I am using CRXI. I have done a left outer join to join two tables and one of the fields in the results will have a null value. I want to create a formula that does (FldA - FldB) but in the cases where FldB is null the formula does not produce an answer. I would like for the...

Hello All, I am looking to recreate a income statement in Netsuite, and am creating this via multiple subreports within a report. I want to create two parameter fields that will indicate the start date and end date of the report. How can I specify the parameter at the report level and have it...

Hello All, I'm trying to figure out how to filter rows out of a report where the sum of a field is less than 50. Thanks.

I'm having a problem creating a formula that will give me the return rates for all my items. All the transaction I'm looking for is based on the same table. I have filtered it so that I only get invoices and credit memos. I have pushed this data into a crosstab report so and used transaction...