4 Replies Latest reply: May 14, 2012 10:22 AM by Thom Mumaw RSS

    Calculation Question (Set Analysis vs. "If")

    Thom Mumaw

      Hello All,

      I am have a small issue trying to get something to work using set analysis and thought maybe someone out here could help.  The first statement works fine, but the second one using set analysis does not.  I was wondering if I am doing something wrong.  Thanks  Thom

       

      1)    Sum(if(Contract_End_Date_Num >= Roll_Out_Date_Num, ExtendedAmount))

       

      2)    Sum({<Contract_End_Date_Num = {">= Roll_Out_Date_Num"}>} ExtendedAmount)