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!

  • 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: BadBO
  • Content: Threads
  • Order by date
  1. BadBO

    Formatting date into hours

    I am trying to build a Business Objects report that breaks daily data into 1 hour sections. I have the measure I want to add to a cross tab but I cannot figure out a good way of splitting time data up into hours throughout the day. I have tried formatting the date/time object into SHORT_TIME...
  2. BadBO

    Plotting a trend line on a chart

    I am trying to plot a trend line onto a line graph in Business Objects. I have hunted high and low and I cannot seem to find a BO function that does this. My data is pretty simple but I cannot figure out how to do this, my data table is in the format below: Date [Measure] 01/01 0 02/02...
  3. BadBO

    Use of Variance formula (=Var)

    I am trying to add a column to a table which shows the daily variance from the previous day. My table looks something like this: Measure Date1 5 Date2 2 Date3 9 Date4 7 I would like to add another column showing the variance from the previous day like this: Measure Variance Date1 5 5...
  4. BadBO

    Using 'Rank' formula in Business Objects

    I have a crosstab in BO and I wish to select the Top 3 values from the measure in the table. I have tried using the rank function but this does not work. My crosstab looks something like this: Name A B C D Date 01/01 10 8 2 02/01 7 03/01 1 9 6 2 I know I need to use the ‘rank’ formula...

Part and Inventory Search

Back
Top