Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Team,
I have come across a requirement in which the the product X has a lag of 2 days.
So when i filter the report for Week = 9/9/2017, then the Product X must show values for the week 9/11/2017.
Filter applied | Week:9/9/2017 | |
Expected Output | ||
X Week | Week | QTY |
9/11/2017 | 9/9/2017 | 100 |
9/11/2017 | 9/9/2017 | 200 |
9/11/2017 | 9/9/2017 | 300 |
original Output | ||
X Week | Week | QTY |
9/9/2017 | 9/9/2017 | 80 |
9/9/2017 | 9/9/2017 | 90 |
9/9/2017 | 9/9/2017 | 110 |
Any help with this would be appreciated.
Thanks,
Harshala
Try this
=Sum({1<date={"$(=date(num(date)+1))"}>}Value)
or this
=Below(TOTAL Sum({1<date={"$(=date(num(date)+1))"}>}Value))
Hi Sunny, i tried the below expressions earlier it doesn't work.
Sum({1<date={"$(=date(num(date)+1))"}>}Value)
also the other expression :
=Below(TOTAL Sum({1<date={"$(=date(num(date)+1))"}>}Value)) - doesn't work if i remove the date field.
Solution: i need ignore the date selection
Sum({< weekdate = {"$(=date(Num(Weekdate)+2,'MM/DD/YYY'))"} ,date= >}QTY)