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

    ceil and set analysis

    Joanna Seldon




      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