Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hello
i want to add an indicateur whith date
i try this
=sum({<mois_a = MonthStart(Today())>} AMOUNT#LOCAL#1)
i want to the sum of amount between the star of month and actual date
thank you
=sum({<mois_a = {">=$(=MonthStart(Today()))<=$(=Today())"}>} AMOUNT#LOCAL#1)
Hope mois_a is date field
it 's always zero 0
this didn't work my be because date form is YYYYMMDD
Then add date format to your expression
=Sum({<mois_a = {">=$(=Date(MonthStart(Today()), 'YYYYMMDD'))<=$(=Date(Today(), 'YYYYMMDD'))"}>} AMOUNT#LOCAL#1)