3 Replies Latest reply: Apr 4, 2016 9:20 AM by Sunny Talwar RSS

    ceil and set analysis

    Joanna Seldon


      Hiya

       

       

      I have the following set analysis measure - temperature conversion working on a table.

       

      ceil ([FirstTemp] - [LastTemp],  0.1)

       

      I wish to add the following to exclude some columns {$<CustomerFlag ={"0"}, ShipperFlag = {"0"} >}

       

      I cannot seem to get this to work,

       

      I have tried with a sum, and it throws out the calculations

       

      please help