topic ceil and set analysis in App Development

ceil and set analysis

joeybird — Mon, 04 Apr 2016 13:00:32 GMT

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

sunny_talwar — Mon, 04 Apr 2016 13:03:48 GMT

May be this:

Ceil(Only({$<CustomerFlag ={"0"}, ShipperFlag = {"0"}>} FirstTemp) - Only({$<CustomerFlag ={"0"}, ShipperFlag = {"0"}>} LastTemp), 0.1)

Only({$<CustomerFlag ={"0"}, ShipperFlag = {"0"}>} Ceil(FirstTemp - LastTemp, 0.1))

joeybird — Mon, 04 Apr 2016 13:17:58 GMT

Hiya

Only({$<CustomerFlag ={"0"}, ShipperFlag = {"0"}>} Ceil(FirstTemp - LastTemp, 0.1))

worked a charm, thank you x

sunny_talwar — Mon, 04 Apr 2016 13:20:44 GMT

Awesome