10 Replies Latest reply: Feb 13, 2015 4:10 PM by Joe Crane RSS

    Set analysis from the same field

    Joe Crane

      Hi,

       

      I'm trying to set something on a table chart that uses an equation that pulls from a previous month/year id:

       

            =(sum({$<SNAPSHOT_MONTH_ID = {SNAPSHOT_MONTH_ID}-1>}, MembershipFlag))/(sum(MembershipFlag))

       

      I want to divide that 2nd snapshot_month_id by the first one. I think my set analysis is wrong though. I simply want to subtract 1 from the current month ID. Is there a way to do this?

       

      Thanks,

       

      Joe