Hi,
Any help on this query which has been taxing me for days would be appreciated.
I'm using CR8, and have a graph that shows the amount of money spent over a specific time line. This line goes up in a wobbly diagonal line (as time goes on the amount spent increases). I also have a line that shows the amount budgeted. At the moment this is a straight horizontal line that runs across the whole time line at the same amount.
Both of these are fine.
However, I now have to show an estimated spend, which should be a diagonal line from bottom left to top right. It should start at zero and go up to the budgeted amount at the end of the time period.
How can I use CR's formulas to work this out? I can't seem to chart on a running total field properly and even when I get something on there its wobbly, as opposed to straight which it should be.
Any help would be much appreciated.
Thanks,
Victoria
Any help on this query which has been taxing me for days would be appreciated.
I'm using CR8, and have a graph that shows the amount of money spent over a specific time line. This line goes up in a wobbly diagonal line (as time goes on the amount spent increases). I also have a line that shows the amount budgeted. At the moment this is a straight horizontal line that runs across the whole time line at the same amount.
Both of these are fine.
However, I now have to show an estimated spend, which should be a diagonal line from bottom left to top right. It should start at zero and go up to the budgeted amount at the end of the time period.
How can I use CR's formulas to work this out? I can't seem to chart on a running total field properly and even when I get something on there its wobbly, as opposed to straight which it should be.
Any help would be much appreciated.
Thanks,
Victoria