Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am attempting to do an accumulation chart of our Freight Costs YTD and LYTD. The LYTD is working great... but with the YTD I only want to see the chart up to the Previous Month.
Currently - it is adding "0" freight costs so my chart flat lines. This is causing my trend line to be inaccurate based on YTD trends.
Try this without full accumulation:
=If(Sum({<Year= {'2015'}>}FreightCost) <> 0, RangeSum(Above(Sum({<Year= {'2015'}>}FreightCost), 0, RowNo(TOTAL))))
I am assuming you are using two expressions. For the expression which is adding bars for future month, you can do something like this:
If(Sum(Value) <> 0, thenAccumulateExpression)
I have added that to my my formula. But still getting the same results.
This is the formula I am using - Sum({<Year= {'2015'}>}FreightCost)
And then I select full accumulation at the bottom.
I think my formula needs to do the accumulation instead of the hot key in the chart properties. But I don't know how to write it.
Try this without full accumulation:
=If(Sum({<Year= {'2015'}>}FreightCost) <> 0, RangeSum(Above(Sum({<Year= {'2015'}>}FreightCost), 0, RowNo(TOTAL))))
YOU ARE MY HERO!
Hahahaha, I am glad it worked
Sunny