Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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))
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))
Hiya
Only({$<CustomerFlag ={"0"}, ShipperFlag = {"0"}>} Ceil(FirstTemp - LastTemp, 0.1))
worked a charm, thank you x
Awesome