#DrSpotfire I am not able to add calculated columns using traansformation, I have taken preprocessor error into account still there is no result neither error visible to me. Can someone please help me with this?

[Rashmi Mohansingh Solanki]

Result expected is the allocation of temperature based on condition mentioned in the calculated column and defined document properties. I have tried some with normal calculated columns and it works perfect with preprocessors($) in it, for calculated columns with transformations I am getting this empty values with no errors.

Any help is appreciated.

[Jose Leviaguirre]

The backslash acts as a escaping character in your column, so it renders as a single backslash.

Add this transformation before your case statement 

Substitute([FILE],"\","\\")

Or replace all your \ with a single in your document properties