Using function today () in set analysis?

[#1]

Good Afternoon,

I wonder how can I use the function analysis on set today?

I need to return in a text object the delinquent amount until the present day.



Ex: sum ({<[Due Date] = {$ (= Today ())}>} [Pending Value])



Already Thank you!

[srinivasa1]

Try as below

sum({<({<[Due Date]={'$(=$(=(Today()) )'}>}[Pending Value]))

For untill today you can write as below

sum({<({<[Due Date]<={'$(=$(=(Today()) )'}>}[Pending Value]))

[#3]

Hello,
tested and did not return anything!

Att,

João Henrique

[#4]

HI ,

       Use this code .

sum ({<[Due Date] = {'$ (= Today ())'}>} [Pending Value])

Please let me know if there is anything.

[MayilVahanan]

HI

Try like this

sum ({<[Due Date] = {"<=$ (= Today ())"}>} [Pending Value])

And make sure, both [due date] and today() are in same format

Hope it helps

[Anonymous]

This should work:

sum ({<[Due Date] = {"$ (= date(Today ()))"}>} [Pending Value])

Regards,

Michael

[#7]

Thank you all for the help...

Att,

João Henrique

[Janneke · Accepted solution]

Hi Joao,

Have you tried

=Sum({<[Due Date]={'<=$(=Date(Today()))'}>}[Pending Value])

?

Regards, Janneke.

[#9]

Thanks!