Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello I have this set analysis like Month to date :
DateCal=,Year=,Month=,Quarter=,
DateCal={">=$(=MonthStart(max(DateCal)))<=$(=date(max(DateCal)))"}
I would like now to do Month to date -1 (if i select April 2017 i will have March 2017 )
Thanks for help
DOS_REF_EXTERNE is my kpi
My bad, I wanted to see it in a table object...
Hello,
I find the problem i need to add year=,month = in the variable :
Year=,Month=,DateCal = {"$(='>=' & MonthStart(Max(DateCal),-1) & '<' & MonthStart(Max(DateCal)))"}
Bro you are a genius, I sometime wonder why do you even seek help as you are able to solve your issue 9 out of 10 times
Hahaha yes sometimes i find my problem