ceil and set analysis

[joeybird]

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 · Accepted solution]

May be this:

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

or

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

[joeybird]

Hiya

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

worked a charm, thank you x

[sunny_talwar]

Awesome