4 Replies Latest reply: Jan 24, 2018 12:26 PM by Prasad Mundewadi RSS

    Set analysis compare 2 fields

    Prasad Mundewadi


      How can i compare values in 2 fields in a set analysis.

      Something like below but i am not able to get the syntax correctly.

      Sum ({<SnapshotQuarter = {<$(=CurrentQuarter)}>}Sales)


      All I want is Sum of Sales for all the SnapshotQtr which are previous to CurrentQtr. And i am specifically looking for a set analysis syntax.


      Thanks in advance.