Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I want to know the meaning of this expression :
sum({<[Month of date]= {">=$(=Date(Month(), 'DD/MM/YYYY'))"}>}Sales)
Thank you
Hi Zied,
This Formula probably only give back nothing, sinds there is a error in the formula. It means:
Show Sales where [Month of date] is equal or greater than the date of a month of nothing
Hi Zied,
This Formula probably only give back nothing, sinds there is a error in the formula. It means:
Show Sales where [Month of date] is equal or greater than the date of a month of nothing
Hello Bert,
How i can select the Max of Month of date?
Thank you
sum({<DateField= {">=$(=monthstart(max(DateField)))<=$(=max(DateField))"}>}Sales)
Make sure that DateField is in proper date format, if not you need to make it in Date format, using Date# function in script
How your months are calculated in the script ?
try this
Month(Max(Date))