Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good Day All,
Having some difficulty here. I am looking for a calculation within two dates.
vToday = date(Today())
vWeekAhead = date(Today()+8)
My set analysis formula is the below :
=Sum({<ReqShipDate = {">= $(vToday) <= $(vWeekAhead)"}>}MStockUnitMass*MOrderQty)
When I use this formula in a chart i can see that the result is what I want :
=Sum({<ReqShipDate = {">= 2018/03/12 <= 2018/03/20"}>}MStockUnitMass*MOrderQty)
But for some reason the calculation isn't correct, it doesn't show any data, although there really is data available. I've tried some of the below solutions. none worked.
=Sum({<ReqShipDate = {'>= $(vToday) <= $(vWeekAhead)'}>}MStockUnitMass*MOrderQty)
=Sum({<ReqShipDate = {'>= $(=vToday) <= $(=vWeekAhead)'}>}MStockUnitMass*MOrderQty)
Please assist.
Regards,
Make sure that your ReqShipDate is a proper date(dual) field and format and the comparison date format are same, i.e. - YYYY/MM/DD
I did, the Reqshipdate is in the format YYYY/MM/DD
I have adapted the variables to also be the same format. Still didn't work, I did however notice now that if I changed the formula to =Sum({<ReqShipDate = {"= $(vToday)"}>}MStockUnitMass*MOrderQty) Just as a test, it works, as soon as I add the greater than ">" things don't work.
Could you post a sample app to investigate?
Just reloaded the data and it worked.
Not sure what the issue was but the formula posted originally was correct.
Thanks for the help.
Please close the thread