9 Replies Latest reply: Jul 20, 2016 10:15 AM by Ruan Ramon Silva Diad RSS

    Sum if or Set Analysis for date minus 1

    Charles Mogashoa

      Good day


      Please assist. I am looking for an expression that will sum today's Doc_type = 'ZZ' with yesterday's Doc_type = 'SA'.

      There is an Entry_date field and I am summing an Amount field.


      Please assist with a set analysis or Sum if statement