Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I tried a bunch of the other solutions that come up with similar questions that have been posted but nothing seems to work.
I have a variable that is vStartDate = Date('01/01/2019')
I want set analysis for Sum(Amount) where SeqCreateDate >= vStartDate. If anyone could help I would greatly appreciate it.
I would store vStartDate as a number like this
Num(Date#('01/01/2019', 'MM/DD/YYYY'))
and then may be like this
Sum({<SeqCreateDate = {">=$(=Date(vStartDate, 'MM/DD/YYYY'))"}>}Amount)
or
Sum({<SeqCreateDate = {">=$(=Date($(vStartDate), 'MM/DD/YYYY'))"}>}Amount)
hi
one thing you must do is to make sure vStartDate
has the same format as SeqCreateDate
than your expression should be
Sum({<SeqCreateDate ={"<=$(vStartDate )"}>}Amount)
I would store vStartDate as a number like this
Num(Date#('01/01/2019', 'MM/DD/YYYY'))
and then may be like this
Sum({<SeqCreateDate = {">=$(=Date(vStartDate, 'MM/DD/YYYY'))"}>}Amount)
or
Sum({<SeqCreateDate = {">=$(=Date($(vStartDate), 'MM/DD/YYYY'))"}>}Amount)