0

sum filtered date in a table

let t := this;

Hi!

please can you know me how can I sum selected filtered date in a table?

This code doesn't work:

let bd:= min(Table1.Date);

let ed:= max(Table1.Date);

sum((select Table1 where Date >= bd and Date <= ed).Amount)

Thank you!

2 replies

null
    • Jorg
    • 5 yrs ago
    • Reported - view

    Hi Sal, 

    Please try:

     

    let bd:= min((select Table1).Date);

    let ed:= max((select Table1).Date);

    sum((select Table1 where Date >= bd and Date <= ed).Amount)

     

    Best, Jörg

    • Sal
    • 5 yrs ago
    • Reported - view

    Hi Jörg,

    Thankyou it works!

Login to reply

Content aside

  • 5 yrs agoLast active
  • 2Replies
  • 1100Views