Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Don't suppose anyone would know how to not have the total accumulation show at the end of a line in a graph that has full accumulation on and just have the last data points value? I made a target line that is the accumulation of double the actual sales accumulation line. It is linear and is the accumulation of the total accumulation of the sales divided by the number of days times 2. The last day has the correct value but there is another step of accumulation added to the total though there are no more days. Here are the accumulation vales for the last five days with the last number being the total.
8-May | $83,691,413.35 | $41,738,021.34 |
9-May | $84,545,407.37 | $42,157,041.42 |
10-May | $85,399,401.38 | $42,699,700.69 |
11-May | $86,253,395.40 | $42,699,700.69 |
$87,107,389.41 | $42,699,700.69 |
Everything is good except for the total. Any ideas on a fix or is this a bug?
Can you post your app?
I got it solved another way.
Please post your solution!
=RangeSum(Above(Sum(Sales),0,RowNo())) and offset the number of days divided on with a + 1. This will get you what you want.
You answered it in a slightly differntly worded post from me Jason!
This question was originally a work around that was solved by an even simpler work-arround stated above.
Ah 🙂
A Starbucks accross from a Starbucks moment?
Something like that 😉