I'm trying to figure out how I can create a formula using all three functions and provide an explanation to what the formula is doing and what the result will be used for. So far this is what I came up with, but I'm struggling to use the function TimeGE - any suggestions?

I tried another way and this is my result. I'm not sure if the output value is correct though.

This is the summary I came up with:

Calculates the difference between DCT3LS and DCT3RS. If the value is less than 100, it is converted to degrees Celsius. Otherwise, the formula determines the total time in the past 3 hours when DCT3LS was greater than or equal to DCT3RS at 8AM today. The formula is still comparing both attributes but only converts the temperature to Celsius if the difference is less than the specified number provided. If not, the formula identifies that DCT3LS was, at some point, equal to or greater than DCT3RS but doesn’t specify how large or small the difference in temperatures were; it specifies the timeframe the temperatures were equal or disparate, in seconds.

The output value can be used to determine the temperature difference between DCT3LS and DCT3RS in Celsius rather than Fahrenheit.

Hi Senterra,

Your use of use of convert function seems a little weird to me. It might be better if it were written as 2 variables. Also, the temperature difference (delta) has its own UoM group, therefore, the conversion will not be different.

Please check out the temperature (Delta) unit of measure group

Best,

Jin