Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2007
    Posts
    7

    Unanswered: Graphing data that 'isn't there'

    I'm graphing a set of data from month to month, but for one month there is no data, and the chart is showing a value of -1. I'm wondering if there's a way to graph that as 100% instead of -1 %.

    I'm using the percentage line graph using a couple running totals from the report.

    Im thinking that another alternative would be to have my running total field to be 1 if it's 0 - so instead of displaying 0 it would display 1. This would solve my issue, but is there a way to do it?

    Thanks

  2. #2
    Join Date
    Jul 2007
    Posts
    54
    Your solution sounds right. I would suggest creating a new formula which is the one you display on the graph. Its formula would be

    If YourRunningTotal = 0 Then 1 Else YourRunningTotal

    HTH
    Caspar

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •