Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have an inline table with due dates, such 30 days, 60 days, 90 days, etc., and need to show the records whose date value is within these periods. After looking up some examples in the Community I have tried two possible solutions that are supposed to work:
Version 1: sum({MyDate={">=$(=vDueDate)"}>}MyAmount)
Version 2: sum({MyDate={">=$(=Today() + DueDateDays"}>}MyAmount)
Where DueDateDays are values of the due dates table and vDueDate variable is set as .Today() + DueDateDays.
But none of them work for me.
Any help?
Thanks.
Alberto.
May be add the missing things
Sum({<MyDate = {">=$(=Date(Today() + DueDateDays))"}>} MyAmount)
This doesn't guarantee that the expression will work... but those things are essentials. Other things might be needed based on your data and exact requirement which isn't very clear.