6 Replies Latest reply: May 6, 2015 9:04 AM by paulo costa RSS

    Date variable and set analysis

    paulo costa

      I have a date variable associated to a calendar object. This variable should be used at the following set analysis expression (text object):

       

      = money(sum({<[Data Receb/Pagto]= {$(#Data Base)}>} [Valor Original]))

       

      It always returns 0 (zero), although having data to sum. The [Data Receb/Pagto] field, when used in a text object returns a "date". The "Data Base" variable, when used in a text object returns a "number". In this way, I thought that the set analysis expression should be changed, but it made no diference:

       

      = money(sum({<[Data Receb/Pagto]= {$(=#date($(#Data Base)))}>} [Valor Original]))


      or


      = money(sum({<[Data Receb/Pagto]= {$(=#num($(#Data Base)))}>} [Valor Original]))



      What is wrong?


      regards,

      Paulo Costa