Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello!!
My date expression is yearmonth and my volume is volume.
I would like a simple method of displaying in my table not the load script
previous month volume. It is not working for me because the date should be in the format of yearmonth.
Can you try this?
=Count({<volume= {"=Date(MonthStart(yearmonth),'MMM-YY')=Date(MonthStart(AddMonths(Today(),-1)),'MMM-YY')"}>} volume)
Hello,
Thank you for responding!
Can you try again please? And explain what your logic means?
the volume portion works however the date format does not.
My date format is like so
=[xxxnameoftable.autoCalendar.YearMonth]
How do you propose adding that to the syntax below?
