I have created a calculated field in tableau as below and it is giving the desired output when pulled as a row value in tabular format.