5 Replies Latest reply: Oct 5, 2015 8:56 PM by Nathaniel Anderson RSS

    Set Analysis Compare two columns

    Dinesh Thoniparambil

      I have a text columns which has values 201001, 201002 etc. I have a different date column as well. How do I write a set analysis which goes something like this:

      sum({<date(date_column,'yyyymm') = {text_column}>} Amount_Column)

      The above is not working. What am I doing wrong?