Data not filtering when field used as set analysis modifier

[k_burata]

Hi, hope you can give me an answer to this.

So I have a table and I am trying to separate the records into Current and Over Due. When I try to select a cell on any column except Due Date, the data is filtered correctly. But when I select any record on the Due Date nothing happens. Is it because I used it in the formula in the Text Box? Can someone help me get the correct set analysis script?

Cheers

Current

     =num(SUM({$<[Due Date] = {">$(=Date(Today()))"} >}[Amount]), '#,##0.##')

Overdue

     =num(SUM({$<[Due Date] = {"<=$(=Date(Today()))"} >}[Amount]), '#,##0.##')

[sunny_talwar]

Try this

Current

    =num(SUM({$<[Due Date] *= {">$(=Date(Today()))"} >}[Amount]), '#,##0.##')

Overdue

    =num(SUM({$<[Due Date] *= {"<=$(=Date(Today()))"} >}[Amount]), '#,##0.##')