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

    Calculation Question (Set Analysis vs. "If")

    Thomas 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)