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 dencom 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: *

  • Users: Fsyeda
  • Content: Threads
  • Order by date
  1. Fsyeda

    WEBI Dynamic Date Range

    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)
  2. Fsyeda

    Fiscal Year to Date

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

    Ranking on a Formula Field

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

    Subraction in Group

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

Part and Inventory Search

Back
Top