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

    Set analysis compare 2 fields

    Prasad Mundewadi

      Hi

      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.