6 Replies Latest reply: Mar 5, 2015 10:07 AM by Scott Gillum RSS

    Formula Question

      I am having issue with a formula not returning the expected value.

       

      Here is my formula:

      =if(Status <> 'Discarded', (sum({<Scenario={"2015 LBE"}>}(Amount * Division_Rate)/1000)),0).

       

      The returned value is not excluding the 'Discarded' values from the sum.