I have a calculation field that works out the course between two geographical points. I would like to display the course as three digits and with the degree notation after it so that it looks like 007^{o} . At the moment it is just showing as one digit which is rather pathetic. The field I am using is a calculation field and the output is Number. If anyone has any idea on how to do this please enlighten me??

PS. The small zero after the 7 should be a superscript zero. It doesn't show correctly in the post.

The Right function is returning the characters from the right hand side of the string. If you calculate course to be 14.65987654 then Right(course; 3) returns 654. Right(course; 6) returns 987654.

Here's a simple way to ensure zero padding and, let's say, precision to four decimal places. The result type must be text for this to work. (Increase the final parameter in Middle from 8 to 10 to obtain six decimal places.)

Let([

$course = 14.025467 ;

$course + 1000

];

Middle(course ; 2 ; 8) & "°"

)

--> 014.0254°

malcolm