You look like blending data source and it's quite difficult to understand your issue without seeing your data set.
Could you attach packaged workbook, please?
Which numbers you are trying to compare against which number?
And what is the criteria of large increasing?
What I'm ideally trying to do is show is when a demand increases by 150% within the time fence.
So for example in the first example, I;m comparing October forecast against November forecast. (it only shows one value right now because i have a table calc showing the difference between the two period of's). I want to show if it increases by 150% within the time fence which is I believe February for the first SKU.
Does that answer your question?
I'm still not exactly sure I'm on right track or not, anyways.
Here is a formula to distinguish more than 150% increase.
[Final Forecast Color]
if ((ZN(SUM([Final Forecast])) - LOOKUP(ZN(SUM([Final Forecast])), -1))
/ ABS(LOOKUP(ZN(SUM([Final Forecast])), -1))) >1.5
then "Red" else "Green" end
You are on the right track! Thank you for providing this.
For the first item on the worksheet - 00CAT00599, how would I get it to only show values or percentage change through February 2017. That is the time fence of the product, and so anything outside of that is irrelevant.
Do you have any tips no that?
Thank you so much!
Yep, I understand how to filter for specific dates through that application. But what I'm trying to see is just the "Extent of Lead Time" and the "Period For".
So for example, if the item A has Extent of Lead Time of March 2017, then it would only show Period For through March 2017. And then if item B has Extent of Lead Time of April 2017, then it would only show Period For through April 2017. But both items on the same worksheet.
Does that help to clarify?