Search results for query: *

IN WEBI 4.0 I need to calculate the sales for last 12 months.(Ex: From Sept 19 2012 till today) This has to be dynamic. I am looking for something like this ; =[Total Sales] Where [Invoice Date] Between (CurrentDate();CurrentDate()-365)

I did apply the suggested formulas Pete, and they work for the report ! I did actually realize that the earlier formulas would have been a problem in the months of OCT, NOV, and DEC. This solution makes everything simple and accurate. The sales formulas are as follows: SalesThisFiscalYear ...

I am sorry to have skipped reading the suggestion from Dunlop in detail. I guess I was too excited to write the solution down. Pete: I am going to try your suggestion and let you know if it works fine.

I don't want it to be hardcoded , I wanted it to be something I can use in future too. I fixed it finally, and the solution is this If ({Table.Fiscalyear} = Year(Currentdate) - 1 and {Table.InvoiceDate} <= Date(Year(Currentdate)-1,Month(Currentdate),Day(Currentdate))) then {Table.sales} It...

Unfortunately, it doesn't help with my issue.

Hello everyone! I am comparing Sales from Last Year Fiscal YeartoDate [EX:(10/01/2011) - 8/16/2012] with Current Fiscal YeartoDate [Ex:10/01/2012 - 08/16/2013] Fiscal starts from October. Below is the Record selection that I am using: {Table.InvoiceDate} in [{@LastFiscalYear_From} to...

The report worked perfectly and it is exactly the way I wanted it to be. Thank you so much Pete :) !

A 2012 YTD will be sales from 01/01/2012 till today. My table has both Calendar and Fiscal. That is not a concern now. And Fiscal for our company is Oct-Sep. Yes, You are right , I need to compare the same time period and not the complete 2012. Example Sales Variance: [Sales in range (...

Oh well, I tried in the above suggestion and it worked fine with regards to the numbers. Thank you for that PETE :). As specified earlier, I need this report to be an YTD report generated every 1st of the month. I talked to the DBA and added in the Calendar Year instead of Fiscal Year. I...

Pete, I tried your code too, it works fine with my report. I am not committed to the structure. At the end of the day the report should have these fields(I hide the FiscalYear group and sales and margin detail) SalesrepName ; SalesVariance and MarginVariance With the SalesVariance descending...

I have tried your code Pete and it works perfect with my report. :)

When I click on Group Sort expert ,It does not show me the formula field to sort on. It shows me report fields (Tablename.attributes/measures) from the Table. I need to sort basis the formula field which I have defined in the report.

I do use run time summaries. can you provide me the details of the steps , since I have tried to get rank but that option is not visible for the formula field(Sales variance) at all. Salesrep1 ---------------------------------------SalesTotal------------MarginTotal...

Hello, I wanted to know how is it possible for me to Rank on a Formula Field. I have three columns : Sales Rep Name; Sales Variance ; and Margin Variance I have calculated the sales and margin variance and used it in the report. Now I need to arrange the report in Descending order of the Sales...

Somehow I managed to get the below query working for my report. I played around with the data a lot and ended up with this Formula working for me. I still do not understand the logic though it works perfectly for my query :P ! Sales Variance : (Sum ({tablename.Salesfield}...

It displays me the sum of the two fields instead of difference(with a negative sign). I have tried to tweak it but it never gives the difference. Running Total doesn't help either.

Ex: Salesrep1 ---------------------------------------SalesTotal------------MarginTotal -----------------------------2013--------1000-----------------200 -----------------------------2012--------3000-----------------700 (I want to...

I have two groups Sales rep and Year(Under sales rep group) I get the sum of Sales and margin in two columns. I need to know how to insert a difference within each group for Sales and Margin. Ex: Salesrep1 Sales Total Margin Total 2013 2000...